View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Have afirst name and last name and want to seperate them.

=LEFT(A1,FIND(" ",A1)-1)
best wishes (with your homework?)
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"lauras03" wrote in message
...
I have a cell with someones first name and last name and want to include
the
persons first name in the middle of a statement.

Example:
A1: Joe Smith
A2: If you, (insert first name here)
A5: more text....

Thanks



--
Thanks,
Laura