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

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

"JCM" wrote:

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

Data Text to Columns Delimited Next Comma Next Finish


"JCM" wrote:

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

Hi,

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


Dave

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