How do I

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Try this:

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

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

XL2002, WinXP
 
Another version............

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

Vaya con Dios,
Chuck, CABGx3
 
Back
Top