extracting numbers from data

T

tufstro

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Remove Identical words 0
Display entire number in cell 3
Getting the difference between a "negative" number and a positive 2
data from multiple files: best way to extract 1
Extraction 3
Extracting data from range and placing in one cell with comma'sbetween while ignoring blanks 5
Extracting numbers from a string containg letters at the end 5

Top