Have afirst name and last name and want to seperate them.
 

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

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