I have a list of model numbers. They start with text, have numbers, then end sometimes with, sometimes without more text.
Can you help write a formula that pulls just the numbers out?
Model Need just Number
MF1225H 1225
Thanks much,
I have a list of model numbers. They start with text, have numbers, then end sometimes with, sometimes without more text.
Can you help write a formula that pulls just the numbers out?
Model Need just Number
MF1225H 1225
Thanks much,
Last edited by bluerog; 02-09-2012 at 02:37 PM.
In H4
=-LOOKUP(2,-RIGHT(LEFT(F4,LOOKUP(1E+100,--MID(F4,ROW($1:$100),1),ROW($1:$100))),{1,2,3,4,5,6,7,8,9}))
and copy down.
Good luck.
Works like a charm. Thanks OnError!
I am trying to do something similar and the above formula (mostly) works. The one problem I am having is when there is a field that does not contain a number I get a #N/A error. Is there a way around that? I've attached an example. In B2, if there is not a discount I would like it to just return the B1 value.
Thanks!
If I'm doing this right (possibly I'm not, this is new to me), I am getting an error in B2 of #VALUE!.
I've looked at the workbook. You just want:
=IF(ISNA(F2),B1,B1-(B1*(F2/100)))
in B2
Thanks, that works!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks