breaking a field out

[JCM]

I have a column of cells that all have a last name followed by a comma and
then a first name. I need to have the last name in one column and the first
name in another. Is there a formula that will take the value of everything
up to the comma and put it in another column regardless of the length of the
name.

Example:
Column A Column B Column C
Smith, Robert Smith Robert
Washington, George Washington George

 

[Tom Hutchins]

In column B (for last name):
=LEFT(A1,FIND(",",A1)-1)

In column C (for first name):
=RIGHT(A1,LEN(A1)-FIND(",",A1))

Adjust the row if necessary and copy down as needed.

Hope this helps,

Hutch

 

[Teethless mama]

Data > Text to Columns > Delimited > Next > Comma > Next > Finish

 

[Dave Curtis]

Hi,

You could also use Data, Text to columns, and select comma as the separator.


Dave

url:http://www.ureader.com/msg/104241296.aspx