How do I

L

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
[email protected]
 
R

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
 
C

CLR

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

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

Vaya con Dios,
Chuck, CABGx3
 
Top