faizumarali
Board Regular
- Joined
- Jul 23, 2008
- Messages
- 89
- Office Version
- 365
- Platform
- Windows
I am looking for a formula to remove special characters (like ' , " & - ) in a sheet.
Thank you.
Thank you.
-
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.
How to remove special characters in excel
- Thread starter faizumarali
- Start date
Sandeep Warrier
Well-known Member
- Joined
- Oct 31, 2008
- Messages
- 2,679
The simplest way is to use Find/Replace (Ctrl+H)
In the Find What area type in "," (without the quotes) and in the replace with area type in whatever you want to replace , with and click the button called Replace All.
You'll have to use this multiple times, once for each character you want to replace)
In the Find What area type in "," (without the quotes) and in the replace with area type in whatever you want to replace , with and click the button called Replace All.
You'll have to use this multiple times, once for each character you want to replace)
Upvote
0
Similar threads
- Question
- Question
