| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy only the number from a text string
Hi,
When a cell contains text as well as a number is it possible then to copy only the number to a new cell? The number does not appear on a certain position from the beginning of the cell as the text varies, but it is always to be found at the end of the string and vary between 3 and 5 digits. Before the number is always a space. There are a different number of spaces in the text also. Regards Kaj Pedersen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting a text word or text string to a number | Excel Discussion (Misc queries) | |||
| Change 3 letter text string to a number string | Excel Discussion (Misc queries) | |||
| Copy Text String from between () | Excel Worksheet Functions | |||
| Extract number from text/number string.. | Excel Discussion (Misc queries) | |||
| Splitting a text string into string and number | Excel Discussion (Misc queries) | |||
Threaded Mode
