retrieving one word

Originally Posted by NBVC

Try:

=MID(A1,SEARCH(B1,A1),SEARCH(" ",MID(A1&" ",SEARCH(B1,A1),255)))

Where A1 contains original string and B1 contains string to search for.

Thanks NBVC
It is working with the word in the beginning of the sentence, but what about the word in the end of sentence??

Originally Posted by oldchippy

Hi,

Just adding to NBVC example and looking at your very first example where its enclosed in brackets, you may need something like this

=IF(RIGHT(MID(A1,SEARCH(B1,A1),SEARCH(" ",MID(A1&" ",SEARCH(B1,A1),255))),2)=") ",LEFT(MID(A1,SEARCH(B1,A1),SEARCH(" ",MID(A1&" ",SEARCH(B1,A1),255))),LEN(MID(A1,SEARCH(B1,A1),SEARCH(" ",MID(A1&" ",SEARCH(B1,A1),255))))-2))

Thanks a lot

Originally Posted by NBVC

It should also work with word at end of sentence...

I tested it with your example#2 and got the expected result.

Have you tried it? What error do you get?

Dear NBVC,
sorry for confusing you
It is working for both examples

Thaaaaaaaaaaaaaanks