=MID(A1,SEARCH("Trf To",A1),LEN(A1))

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"MervB" wrote in message
...
Mouthful ain't it!
Basically I have a text variable which can be of any length but includes
the
phrase "Trf To". I want to modify the text by trimming all character to
the
left of the phrase.

MervB
:-)