How do I

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

Guest

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)
 
Larry,

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

VBA Noob
 
=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)
 
Back
Top