MrExcel Publishing
Your One Stop for Excel Tips & Solutions

stripping first number from a string


Posted by j ross on December 04, 2001 11:04 AM

I need to strip off the first number of a string if it meets a certain criteria (as in, there are 3 digits before the forward slash).


Posted by Aladin Akyurek on December 04, 2001 11:36 AM

Care to give more examples with expected results?

Aladin

Posted by Mark W. on December 04, 2001 12:08 PM

=IF(AND(ISNUMBER(MID(A1,FIND("/",A1)-{3,2,1},1)+0)),MID(A1,FIND("/",A1)-3,1),"")