I have a excell spead sheet the has a field for named FullName and it
displays like this... Lastname, Firstname

I'm going to use this field to do a mailing and I want to break the field up
and mail out Firstname Lastname

any help from one of you guru's would be appreciated.

Larry Hughes

Larry,

Can you expand a bit and show a example of what you want to achieve and
in what cell

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=552905

=LEFT(A1,FIND(",",A1)-1)

=MID(A1,FIND(",",A1)+2,99)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Larry Hughes" <Larry wrote in message
...
I have a excell spead sheet the has a field for named FullName and it
displays like this... Lastname, Firstname

I'm going to use this field to do a mailing and I want to break the field
up
and mail out Firstname Lastname

any help from one of you guru's would be appreciated.

Larry Hughes

=RIGHT(A2,LEN(A2)-FIND(" ",A2))&", "&LEFT(A2,FIND(",",A2)-1)