How do I
 

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

How do I
 

Try this:

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

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

XL2002, WinXP


"Larry Hughes" wrote:

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

How do I
 

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

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

Vaya con Dios,
Chuck, CABGx3



"Larry Hughes" wrote in message
...
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