I need a function who extract the number out of the string below. The amount can be different from the example. There is always a thousand seperator and the text can be other single words.
5 000 Gross
I need a function who extract the number out of the string below. The amount can be different from the example. There is always a thousand seperator and the text can be other single words.
5 000 Gross
Last edited by mkvassh; 04-07-2010 at 05:25 PM.
Try
=1*MID(A1,MATCH(TRUE,ISNUMBER(1*MID(A1,ROW($1:$9),1)),0),COUNT(1*MID(A1,ROW($1:$9),1)))
Where A1 is the cell with text
PS Confirm w/ Ctrl+Shift+Enter
Last edited by contaminated; 04-07-2010 at 05:14 PM.
Люди, питающие благие намерения, как раз и становятся чудовищами.
Regards, ?Born in USSR?
Vusal M Dadashev
Baku, Azerbaijan
It will not work. Can you attach a spreadsheet with your example?
mkvassh,
See the attached workbook "Extract number or text out of a string - mkvassh - SDG10.xls" with Function "TextNum".
Have a great day,
Stan
Windows 10, Excel 2007, on a PC.
If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
Thanks a lot :-)
Regards,
Magne
Thanks for the formula. . But me having numbers in fractions. . such as 5.5,65.5 etc. . could you plz help on this issue. . ??
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks