Parse cell contents ?

F

Fullam

Hi,

I have a LOOKUP formula pulling in a mixed text and number cell into a
table which is used for creating a chart.

The cells appear thus - RR1 thru to RR7. For the chart I need to just
pick out the number element ie 1 thru to 7.

Is there a parse formula I could use or is there a way of formating the
cell such that it ignores the "RR" prefix and recognises the following
number for the chart ?

Best Regards
Greg
 
B

Bondi

Hi Greg,

Try this one where A1 is the reference to your cell with RR1 or
something.

=MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&{0,1,2,3,4,5,6,7,8,9})),1024)

It will extract the numeric values.

I'm sure i saw a more elegant version of it in this group a couple of
days ago but i think this will work aswell..
 
B

Bondi

Hi again,

If it is always the same length and numbers you should rather just use

=Right(A1,1)

Regards,
Bondi
 
Top