| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to extract left-most number from a string
Hi,
I have a column of data that looks like .......0.... .......0.... .........2.2. .........2.2. ..11.2.2.2.2.2.2.2.2. 2.2.2.2.2.2.2.... ........2...2 ........2... 2.2.2.2.2.2.2.2.2.2. I would like to extract the left-most number from each cell. How can I do this with a formula? The number will be either one or two digits. Thanks, Jason |
| 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 | |||
![Jason[_11_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
