Field Display

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top