Here is a formula which evaluates Cell A1 and returns the middle 3 or 4
digits...

=IF(ISNUMBER(VALUE(MID(A1,6,1))), VALUE(MID(A1,3,4)),VALUE(MID(A1,3,3)))
--
HTH...

Jim Thomlinson


"Kevin O'Neill" wrote:

I have cells that look like so...

SS600S162-43
SS1100S162-43

I need to Pull the 600 or 1100 out of the string.

The string will always look like

Letter *** Letter *** 3-4 #'s *** Letter *** Letter *** ###-##

I need to pull the 3-4#'s out of the middle of it for use.

Thanks.