does anyone have a suggestion on how I can remove characters from a cell that contains both characters and numbers. For example, I have a cell that currently contains CK: 8042. I want a macro (or formula) that will edit the cell, and remove all the characters & spaces, and leaves me only with 8042. and then I want it to repeat the process on the next cell below it, and so on until there are no more entries to edit. Thanks
The most "natural" way would be by using regular expressions - see for instance: http://stackoverflow.com/questions/9...icrosoft-excel
Best Regards,
Kaper
PS. see also for instance http://www.excelforum.com/excel-gene...-digits-2.html on this forum - there is a link to simple add-in library whicj includes also regular expressions: http://download.cnet.com/Morefunc/30...-10423160.html
• Select your workbook
• ALT+F11...to open the VBA editor
• Insert.Module...to create a general module to hold the code
• Copy the below VBA code and paste it into that module
• Select the range to be converted
Please Login or Register to view this content.
• ALT+F8...to open the macro window
• Select RemoveNonNums....Click: Run
Is that something you can work with?
Ron, that macro worked. thanks a lot
Glad you got something you can use!
Please be sure to mark this thread as SOLVED (from the Thread Tools menu)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks