| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to extract left-most number from a string
Very nice, Harlan.
-- Regards Roger Govier "Harlan Grove" wrote in message ... "Roger Govier" <roger@technology4unospamdotcodotuk wrote... I think perhaps you missed the OP's point about the numbers being 1 or 2 digits. Row 5 of his test data has the number 11 ... "Harlan Grove" wrote in message ... =MID(A1,MIN(FIND({0;1;2;3;4;5;6;7;8;9},A1&" 0123456789"),LEN(A1)+1),1) Good point. Change the formula to =LOOKUP(100,--MID(A1,MIN(FIND({0;1;2;3;4;5;6;7;8;9},A1&" 0123456789"),LEN(A1)+1),{1,2}))&"" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract a number from a variable text string | Excel Discussion (Misc queries) | |||
| Easiest way to extract characters in a cell LEFT or RIGHT of a sym | Excel Worksheet Functions | |||
| Extract number from text/number string.. | Excel Discussion (Misc queries) | |||
| Extract sub-string of number from field of long series of numbers | Excel Worksheet Functions | |||
| How to extract the Number from a String | New Users to Excel | |||
![Roger Govier[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
