Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
extracting numbers from data
Hi,
Is there a way to extract the numbers, remove them and place them in an adjacent column from the cells in the example below? The LEFT function does not do the entire trick, since the amount of numbers differs per cell and I still need to delete the number in the original cell. 1bla 1.1blabla 1.1.1blablabla 1.1.1.1blablablabla Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
Two Questions: R1C1 and stop text number converting to data | Excel Discussion (Misc queries) | |||
Extracting Comma Seperated data into individual Cells | Excel Discussion (Misc queries) | |||
ranking query | Excel Discussion (Misc queries) | |||
Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions |