Gordon,

Try the following formula

=MID(A1,FIND(" ",A1,FIND(" ",A1)+1)+1,LEN(A1))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Gordon" wrote in message
...
Hi...

I want to extract text from a cell in much the same way as you
would use the
left or right function. However, I want to just ignore the
first two words in
the cell and copy to another cell the remaining text. For
example, this is a
typical cell...

Summer Term St Thomas High School.

I want to remove the Summer Term and keep the St Thomas High
School...

This problem is driving me nuts. Grateful for any help...

Gordon.