Need to remove characters that aren't letters or numbers
Posted by Andrew S. on February 08, 2002 6:56 AM
I have a spreadsheet that contains various non-numeric
and alphanumeric characters (- [ $ ,) that I'd like
to remove from the spreadsheet, while leaving the
alpha and numeric info. What's the best way to
accomplish this?
Thanks.
Posted by JackJoyce on February 10, 2002 12:43 AM
An easy solution is to write a macro to do this for you. Go to tools, macro, record macro. Make sure you record your macro under personal.xls in order to make it available to any worksheet.
Once the record macro is in operation go to "edit", scroll down to "replace" on the toolbar. Type in a character you want to replace and replace it with nothing. Repeat this for any character you want deleted from your spreadsheet and then stop recording your macro.
Then everytime you load a spreadsheet, click the macro and all the characters you want removed will be deleted.
Any problems, let me know.
