Field Display
 

I have a column that displays a person's lastname,firstname.
How can I separate it, so that one column is just the last name, and another
is the firstname.

Use Data | Text to Columns and use the comma as the delimiter

Regards

Trevor


"Metalteck" wrote in message
...
I have a column that displays a person's lastname,firstname.
How can I separate it, so that one column is just the last name, and
another
is the firstname.

Assuming your name is in A1.........
This will pull out the LastName.........=LEFT(A1,FIND(",",A1,1)-1)
And this will pull out the FirstName.. =MID(A1,FIND(",",A1,1)+1,99)

Then just copy these formulas down as far as you have data in column A.


Vaya con Dios,
Chuck,, CABGx3


"Metalteck" wrote in message
...
I have a column that displays a person's lastname,firstname.
How can I separate it, so that one column is just the last name, and
another
is the firstname.