split string into multiple columns

**bmccall17** · 01-17-2007, 10:00 AM

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?!

btw: the data came from WORD.

Thank you,
bam

**jasoncw** · 01-17-2007, 10:25 AM

Assuming "companyName - accountName" is in cell A1:

Cell B1:
=LEFT(A1,FIND("-",A1,1)-2)

Cell C1:
=RIGHT(A1,LEN(A1)-D16-1)

**oldchippy** · 01-17-2007, 10:25 AM

Go to Data > Text to column

**jasoncw** · 01-17-2007, 10:27 AM

Originally Posted by oldchippy

Go to Data > Text to column

Yeah, that is easier. Select Delimited, after clicking Next, make sure Space is checked, and use a - in the Other field.

**oldchippy** · 01-17-2007, 10:29 AM

Easiest, cleanest, quickest probably

**ExcelIsEasy** · 02-17-2012, 05:13 AM

Originally Posted by jasoncw

Yeah, that is easier. Select Delimited, after clicking Next, make sure Space is checked, and use a - in the Other field.

Here you have tutorial which can help in case of some problems: Text to columns

**Pepe Le Mokko** · 02-17-2012, 06:40 AM

5-year old thread....

**Nisha Dhawan** · 02-13-2015, 11:51 PM

Hello Everyone,

You can go through this link as well to learn many more things about how to "split a cell into multiple columns".

http://www.exceltip.com/tips/splitti...ent-cells.html

Thanks
Nisha

**Arpita_Excel** · 06-05-2015, 12:27 AM

Hello Everyone,

You can use below formulas:-

Company Name:- =LEFT (A2, SEARCH ("-", A2))
Account Name:- =RIGHT(A2,LEN(A2)-SEARCH("-",A2,SEARCH("-",A2,SEARCH("-",A2)+1)))

Thanks