Hello All,
Is it possible to create a macro that will go through a column of cells and remove only the text leaving a number? I have imported many cells that have for example "Size:342". I would like to be able to have a macro go through and delete all the text just leaving the number. Is this possible?
Thanks
If the numbers are always preceded with : you could run an Edit -> Replace on your column replacing: *: with nothing... if that's not the case could you provide some more example strings - there are a number of approaches available.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks