| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Extrapolate numeric values from text string
MarcusA wrote...
How can I test for a numeric value in the first position of a text string? If you mean a decimal numeral as first character, try =COUNT(-LEFT(string,1)) The negative sign just before LEFT is intentional. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can you find specific text in a string ignoring any other text | Excel Discussion (Misc queries) | |||
| Equation in text string? | Excel Discussion (Misc queries) | |||
| dynamic cell reference within a text string | Excel Worksheet Functions | |||
| How do I LOOKUP text values | Excel Worksheet Functions | |||
| Finding Specific Text in a Text String | Excel Worksheet Functions | |||
Threaded Mode
