KHURRAM RAZZAQ
New Member
- Joined
- Oct 13, 2016
- Messages
- 5
- Office Version
- 2021
How to remove more than one spaces in excel columns by using excel formula ? Trim & Clean formula is not working .
-
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 more than one spaces in excel columns ? Trim & Clean formula is not working .
- Thread starter KHURRAM RAZZAQ
- Start date
Fluff
MrExcel MVP, Moderator
- Joined
- Jun 12, 2014
- Messages
- 90,703
- Office Version
- 365
- Platform
- Windows
What version of Excel are you using?
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)
Maybe
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)
Maybe
Excel Formula:
=trim(substitute(a2,char(160),""))
Upvote
0
Solution
Similar threads
- Question
- Solved
