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

<douglascfast@hotmail.com> a écrit dans le message de news:
1147875520.907620.287350@i39g2000cwa.googlegroups.com...
> 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
>