| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract numeric characters plus one character...
I have the following text on a column's row where I need to extract
only the numeric characters plus one. ABCDEFG 10M ABCDEFG. I'd like to extract only the 10M (numeric values plus one character on the right) for each item. I'm dealing with thousands of rows of similar data but I'm not sue how to achieve this. Can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Numeric values as character in CSV | Excel Discussion (Misc queries) | |||
| how do I convert numeric value to its character value ex. 10=Ten | Excel Worksheet Functions | |||
| extract data up to a certain character | Excel Worksheet Functions | |||
| only extract numeric value from alpha numeric cell | Excel Discussion (Misc queries) | |||
| HOW DO I EXTRACT ALL CHARACTERS AFTER 5 CHARACTERS ON LEFT | Excel Worksheet Functions | |||
Threaded Mode
