| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula for pulling only numbers but not text from another cel
I hadn't seen that post when I posted again. I'm about to try it. Keep your
pants on. "Ron Rosenfeld" wrote: On Thu, 17 May 2007 11:06:00 -0700, Jamie wrote: OK - I apologize - the example I gave you was just an example and not exactly what I need. I tried to follow your formula as a template for my specific need and had trouble, Let me explain exactly what my situation is: Scenario: Sheet 2, Cell B50= Change0.320 I want: Sheet 1, Cell C27 to = 0.320 Worksheet B, Cell D27 to = Change And what was the problem with RagDyer's suggestion? =LOOKUP(99^99,--MID(A2,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9}, A2&"0123456789")),ROW(INDIRECT("1:"&LEN(A2))))) --ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling text from a cell | Excel Worksheet Functions | |||
| function for pulling certain numbers from a cell? | Excel Worksheet Functions | |||
| extract number and use in formula from text & numbers in cell | Excel Worksheet Functions | |||
| pulling text into a sum formula | Excel Worksheet Functions | |||
| Help creating a formula, pulling from a set of static numbers. | Excel Worksheet Functions | |||
Threaded Mode
