left, right,mid?

S

stumped

Can someone please post code for finding the last value
after the last comma in a string? For example, in the
string:
SplitDummy,"SplitDummy","","","",36,3,8
I need the last value. This is a variable length string
and the last value could be a single, double, or triple
digit value.

Thank you
 
F

Frank Kabel

Hi
one way: use the following array formula (entered with
CTRL+SHIFT+ENTER)
=MID(A1,MAX(IF(ISNUMBER(--MID(A1,ROW(INDIRECT("1:1024")),1)),ROW(INDIRE
CT("1:1024"))))+1,10)
 
Top