| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Parse cell contents ?
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
| How do I find the contents of a cell using the "ADDRESS" function. | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
