How do I

[Larry Hughes]

I have a excell sheet that has a field call FullName and the data is
formatted as follows... Lastname, Firstname ie Hughes, Larry

I want to do a mailing using this data but I would like this field formated...
Firstname Lastname

any help would be greatly appreciated!

Larry Hughes
(e-mail address removed)

 

[Ron Coderre]

Try this:

For A1: LastName, Firstname
B1: =MID(A1&" "&A1,FIND(",",A1)+2,LEN(A1)-1)

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[CLR]

Another version............

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

Vaya con Dios,
Chuck, CABGx3