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