Thread: How do I
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 380
Default 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