How do I

[Larry Hughes]

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
(e-mail address removed)

 

[VBA Noob]

Larry,

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

VBA Noob

 

[Bob Phillips]

=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)

 

[excelent]

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