FORMATTING CELLS FOR A PERSON'S NAME

L

Luthdawg

Is there a way to format a cell that currently reads [Last Name, First Name]
to make it read [First Name Last Name], or even to create two cells that read
[First Name] [Last Name].
 
P

Peo Sjoblom

No. However you can use other means than formatting. However names due to
their big differences are pretty hard to cover. But if you only have one
last name and one first name separated by a comma you can use a help column
and formulas

=MID(A1,FIND(" ",A1)+1,1024)&", "&LEFT(A1,FIND(",",A1)-1)

will reverse the order
 
G

Gary''s Student

If A1 contains:
Smith, Michael
then:
=REPLACE(A1&" "&LEFT(A1,FIND(",",A1)-1),1,FIND(",",A1)+1,"")
will return:
Michael Smith
 
Top