| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing various combinations of text and returning only a number inexcel
A very good day to all,
I am looking for a formula that would remove all non-numeric data from cells and return only a number. PS- notice that there is one numeric character that also needs to be removed - the number after the "m". also note that the formula must be able to handle each variation of text below. Data: A1 = "Gaz = 3 421 786 m3" A2 = "Gaz=3 421 786 m4" A3 = "Gaz=3421786m5" A4 = "Gaz = 3,421,786 m6" A5 = "Gaz=3,421,786m7" A6 = "Gaz =3 421 786 m3" Result: The resultant for each line should be "3421786" Looking forward to see the result. Thanks :-) Submitted via EggHeadCafe - Software Developer Portal of Choice Dynamic ASP.NET charts with Office Web Components http://www.eggheadcafe.com/tutorials...charts-wi.aspx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| number combinations. | Excel Worksheet Functions | |||
| All Possible Number Combinations | Excel Discussion (Misc queries) | |||
| Sorting number combinations | Excel Discussion (Misc queries) | |||
| number range returning a text value | New Users to Excel | |||
| Number combinations | Excel Worksheet Functions | |||
Threaded Mode
