split "abc,123"

  • Thread starter Thread starter Kyli
  • Start date Start date
K

Kyli

I need to find a formula to split Column A: "abd,123" into
column B: "abc" and column C: "123".

I know there has to be a "mid" function or something that
allows me to pull everything before the comma into one
cell and another to pull everything after the comma into
another cell.

Please let me know if anybody knows the answer to this.

P.S. The file is already created, there are other columns,
and I cannot open the file under deliminated because of
the other information. Thanks.
 
One way:

Select the cell(s) and choose Data/Text to columns...

In the first pane, choose Delimited, then click Next

In the second pane, check the Comma checkbox, then click Next

In the third pane, change the Destination address to column B, then
click OK.
 
Kyli, in Column B =LEFT(A1,FIND(",",A1)-1); in Column C
=MID(A1,FIND(",",A1)+1,255).

Note that you could also use the Text to Columns command on the Data menu to
accomplish basically the same thing. Only difference is that that would
leave "abc" in Column A and put "123" in Column B.
 
Okay, now I feel stupid. I didn't know that existed up
there. Could I have asked for anything more simple? This
is going to help...A LOT. Thank-you everyone for all your
formulas and help.

Thanks!
 
Kyli

Copy Column A to column B.

Insert a blank column to the right of column B.

Select column B then Data>Text to Columns>Delimited>Comma>Finish.

Gord Dibben Excel MVP
 
Back
Top