Deleting string before certain string (word)

[Perex]

Hi guys,

I have a problem - the thing is I need to delete every word (string) before the word "from".
The example is:

CAT HILL(A110 PART) From OPPOSITE EAST BARNET ROAD To B/BDY 45 m PAST MANSFIELD AVENUE

and I want to have:

OPPOSITE EAST BARNET ROAD To B/BDY 45 m PAST MANSFIELD AVENUE

I have over 3k records, I imagine this isn't very difficult task, but I'm not very good with VBA;-)

Cheers,
Peter

[martindwilson]

=MID(A1,SEARCH("from ",A1)+5,255)
or if there is only ever one "from" use find/replace find "*from " (without quotes but include space)
replace with nothing

[DonkeyOte]

see also REPLACE function.