I think that would work for most numbers but not all - there might be
"st of" or "nd of" or "rd of" cases too.

..o.


On Sep 10, 4:20 pm, Gary''s Student
wrote:
with 74th of 9354 in A1,

=LEFT(SUBSTITUTE(A1,"th of ","?"),FIND("?",SUBSTITUTE(A1,"th of ","?"),1)-1)
displays 74

and
=RIGHT(SUBSTITUTE(A1,"th of ","?"),LEN(SUBSTITUTE(A1,"th of
","?"))-FIND("?",SUBSTITUTE(A1,"th of ","?"),1))
displays 9354
--
Gary''s Student - gsnu2007