Hi Again,

I found the formula for you.
Extract last word: =RIGHT(A1,LEN(A1)-FIND(" ",A1,1))
Extract first word: =LEFT(A1,FIND(" ",A1)-2)


--
Kevin Lehrbass
www.spreadsheetsolutions4u.com


"Access Front End" wrote:

Hi Anyone!

How do you FIND a string in a cell. I know that in C language you can use
"string" but what do you use in Excel. I have a cell that contain First name
then comma some time a space then Last Name. How can I get the Firstname in
one column & Last name in one column by using the formula. Thanks

Ngan