DougDodge
asked on
How do I clean the data in a cell or special characters, spaces, and carriage returns?
I am trying to clean and normalize data. Cells have carriage returns in them (Alt+Enter), special characters (%^*)/!~), and blank non printing characters. I have come across a few different methods, but each is a separate operation.
Is there a way to select the cells in question, and have a macro perform it all?
The attached file has the three different processes that I have found so far. Two are subs and one is a function. I am hoping to combine them so that one macro can do all three exercises at once.
Thanks for having a look....
Remove-Returns-And-Special-Characters.xl
Is there a way to select the cells in question, and have a macro perform it all?
The attached file has the three different processes that I have found so far. Two are subs and one is a function. I am hoping to combine them so that one macro can do all three exercises at once.
Thanks for having a look....
Remove-Returns-And-Special-Characters.xl
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks....