Formating First Name and Last Name
 

Change: LastName, FirstName

TO: FirstName LastName

Would like to do the formatting in one equation and one step.

Formating First Name and Last Name
 

Data/ Text to Columns/ Delimited/ by comma
--
David Biddulph

"Chico" wrote in message
...
Change: LastName, FirstName

TO: FirstName LastName

Would like to do the formatting in one equation and one step.

Formating First Name and Last Name
 

=RIGHT(A1,LEN(A1)-FIND(" ",A1)) & " " & LEFT(A1,FIND(",",A1))

Thus
Ravenswood, James
will become
Janes Ravenswood
--
Gary''s Student - gsnu200785


"Chico" wrote:

Change: LastName, FirstName

TO: FirstName LastName

Would like to do the formatting in one equation and one step.