I have an Excel file (form) with several macros embedded that do a variety of functions. When a user saves their Excel file, I have a macro which creates a CSV copy of the values input so that I can load to my database. From time to time, a user will copy and paste something into the Excel file which has a special character. My database is unable to read files with special characters, so as a result, no CSV file is generated when the user saves. I would like to write a macro that searches all sheets in the file and removes any special non text characters. Does anyone have a macro they currently use for this now. Thank you in advance.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Remove All Special Characters
- Thread starter JADownie
- Start date
Excel Facts
Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
Rick Rothstein
MrExcel MVP
- Joined
- Apr 18, 2011
- Messages
- 38,522
- Office Version
- 365
- Platform
- Windows
Do you mean include them so they will not be deleted? If so, dots (periods I presume) are easy but spaces would depend on what kind of text you have and how they should look afterwards. For example, could you have multiple adjacent spaces and, if so, should they all remain (currently, my code collapses multiple spaces down to single spaces)? What about text like AB-CD... should the dash be deleted or converted to a space (currently, my code replace the dash with a space)? There are probably other situations I am not thinking of at the moment, so it would be helpful if you posted several representative example text strings that you could have and then show us what you want them to look like afterwards.
Upvote
0
Similar threads
- Solved
- Solved
