Split string into multiple columns in Excel

I am attempting to take the following string:
"companyName - accountName"
and transpose it to multiple columns so it reads like this
"companyName" "accountName" in separate columns

Can some help educate me about the formula I would use to do such a thing?!


In column A2 type =LEFT(A1;FIND("-";A1)-1)  and in A3 type =RIGHT(A1;LEN(A1)-FIND("-";A1))

(for formulas, depending on your country, you might have to change ; with , or the opposite


 Other excel answers



You can find similar Excel Questions and Answer hereunder

1) I have angle values in radians. In Excel, how can I convert them to degrees?

2) I have a column header Title that is big - I cannot increase the size of column. In Excel, how can I somehow fit the Title retaining the existing column width?

3) Find and count instances of a character in a string in Excel

4) How can I sort data using multiple criteria?

5) Vlookup to return max value from multiple hits in Excel

6) How can I enter multiple lines of data in a cell?

7) How to hide and unhide rows and columns in excel VBA

8) How to hide and unhide rows and columns in Excel

9) I work with a SW that returns Hex values - how can I convert them to decimal values?

10) How to rename multiple sheets easily with VBA


Here the previous and next chapter