Excel formula for seperating two words in the same cell.

G

Guest

How do I seperate two words in the same cell, seperated by a comma into to
seperate cells. eg. John,Smith (in cell A1) converted to John (in cell B1)
and Smith (in cell C1)?
 
D

Dave Peterson

Select column A and do
Data|Text to columns
Delimited
by comma
and make sure you put the output in column B
 
C

CLR

In cell B1 put =MID(A1,1,FIND(",",A1,1)-1)

In cell C1 put =MID(A1,FIND(",",A1,1)+1,99)

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text entered in two separate cells appear as one word in another 1
Excel Linking Multiple cells to One cell for Results 0
Swapping two word and placing them in another cell 1
help with spliting data cells 1
Put all cells in one cell seperated by comma 6
Swapping two words in one cell 1
Strip out text copy and paste? 2
SUM of subtracting and then adding different cell 1

Top