On Oct 21, 8:46*am, John Calder
wrote:
Hi

I run Excel 2K

I have a number of text strings with each string containing a key word which
is located in different postitions of each text string.

I need a formula that extracts only that key word from the text string.

Lets say the word is TEST

Thanks

I assume you want to keep the rest
One way

Use "edit" "replace...."
In the find you enter <spaceTEST<space
in the replace you enter nothing

If the word happens to be right at the end or beginning of the text
string you have to do it again without the space at the end or start
of the "find what" entry.
Greetings from NZ