Hi,

Try this with your text string in a1 and the number of the word to extract
in b1

=MID(MID(MID(SUBSTITUTE(A1," ","^",B1-1),1,256),FIND("^",SUBSTITUTE(A1,"
","^",B1-1)),256),2,FIND(" ",MID(MID(SUBSTITUTE(A1,"
","^",B1-1),1,256),FIND("^",SUBSTITUTE(A1," ","^",B1-1)),256))-2)

Mike

"JAF-In" wrote:

hi
if i want to retrieve more than one words
Eg: All names except last name?

Regards

"Mike H" wrote:

Try this

=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),99))

Mike

"JAF-In" wrote:

Hi
How can i remove a Right side word from a set of words in one column
i need to substract the last names in to another column
eg: James William Watson... In this case i need to to take" Watson to the
next column

Regards