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

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

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