help me to find a way to remove space without user intervention.

Originally Posted by erkamu

Thanks a lot my friend. Worked very well.

You're welcome.
Note: Is it possible for users to enter data (in the range in question) by copying-pasting data to more than one cell at once?
If yes then we need to modify the code, because the code will not work if that happens.