Assuming your text is in A4, enter the following formula in B4:
=TRIM(MID(A4,SEARCH("from",A4)+5,LEN(A4)-SEARCH("where",A4)))

HTH
--
AP

a écrit dans le message de news:
...
All,

I am looking to rid myself of extra information in a column, and doing
so in a Macro

Here is what I have in column A

SELECT Column1, Column2 From Mydb.Myspace.My table Where Column1 =
'Hello"

I want to frind the FROM word (There is only one in the cell) and
delete all to the Left including the from

Then Find the WHERE (If it exsists) and delete all to the Right
including the WHERE

And I would end up with column A

Mydb.Myspace.My table

I have several examples of removing single char or commas from the
column, but not entire words.

Any ideas?

Doug