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


--
Fullam
------------------------------------------------------------------------
Fullam's Profile: http://www.excelforum.com/member.php...o&userid=33363
View this thread: http://www.excelforum.com/showthread...hreadid=538068

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..

You could try:

=value(right(A1,len(A1)-2))

"Fullam" wrote:


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


--
Fullam
------------------------------------------------------------------------
Fullam's Profile: http://www.excelforum.com/member.php...o&userid=33363
View this thread: http://www.excelforum.com/showthread...hreadid=538068

Hi again,

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

=Right(A1,1)

Regards,
Bondi

Hi Barb, Bondi,

thats great and they work !

thanks for your help

Greg


--
Fullam
------------------------------------------------------------------------
Fullam's Profile: http://www.excelforum.com/member.php...o&userid=33363
View this thread: http://www.excelforum.com/showthread...hreadid=538068