Thread
:
How do I
View Single Post
#
3
Posted to microsoft.public.excel.programming
Bob Phillips
external usenet poster
Posts: 380
How do I
=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
Reply With Quote
Bob Phillips
View Public Profile
Find all posts by Bob Phillips