davesexcel.com

Excel information

Untitled 1

Extract Numbers From Text String
This code will extract the numbers from a string and place the number in the next column.




 

Before

After

 

Download the example.

Extract number from text.xlsm