FORMATTING CELLS FOR A PERSON'S NAME
 

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

FORMATTING CELLS FOR A PERSON'S NAME
 

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




--
Regards,

Peo Sjoblom


"Luthdawg" wrote in message
...
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].

FORMATTING CELLS FOR A PERSON'S NAME
 

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


--
Gary''s Student - gsnu200715


"Luthdawg" wrote:

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