Excel programming

[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.

 

[Juan Sanchez]

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

 

[Bob Phillips]

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)