Excel programming

  • Thread starter Thread starter Samuel John
  • Start date Start date
S

Samuel John

I would like to have the formula to drop in a cell that
will separate first name, last name and will put the last
name and the first name in two different cells. Note:
last name, first name is now the data is entered.
 
Samuel

For last name: =TRIM(LEFT(A1,FIND(",",A1)-1))
For Fist name: =TRIM(RIGHT(A1,LEN(A1)-FIND(",",A1)))

Assuming format is ALLWAYS Last Name, First Name

Cheers
Juan
 
Look at Data>Text To Columns with comma as the separator.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top