ryan_law2000
Well-known Member
- Joined
- Oct 2, 2007
- Messages
- 738
So im looking for some code that will do the following:
When anything is typed into a cell in range B2:C20
remove all spaces after data is entered.
example:
"B 452 CV 120" (after enter is selected / or different cell selected then it will look like:
"B452CV120"
how can this be done?
I know there is a formula that can do this in a different cell but I'm trying to stay away from formulas in this case.
When anything is typed into a cell in range B2:C20
remove all spaces after data is entered.
example:
"B 452 CV 120" (after enter is selected / or different cell selected then it will look like:
"B452CV120"
how can this be done?
I know there is a formula that can do this in a different cell but I'm trying to stay away from formulas in this case.