Hello there!
I hope someone can help me here. I have been searching for a solution for this for a long time without any joy.
I need to delete all text and characters BUT numbers (including decimals) from my exel spreadsheets. I am using office 2007. Is there a macro to do this?
for example I want a cell containing "brownfox (123.13)" to remain with just "123.13", a cell containing "brown12white" to remain with just "12", a cell containing "blue 1.32" to remain with just "1.32", a cell containing "black10" to remain with just "10", a cell containing "white 2" to remain with just "2". Need to do this for many records
Please help. Thanks in advance!
Regards
Cool
Bookmarks