Data Extraction from a cell
Here it is as a formula...
=RIGHT(A1, LEN(A1)-FIND(" ", A1,FIND(" ",A1)+1))
Did you need it in code. If so it would be approximately the same thing only
with the instr function.
--
HTH...
Jim Thomlinson
"Gordon" wrote:
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.
|