I have some alpha Numeric number in Column-B like below. Starts from cell B2
DC-1
D C - 1
D C-2
DC-2
DC- 4
DC-4
DC-4
DC -4
10 02 4
I need VBA code to Remove all spaces in the data. It should remove space from B2 to till the end of the last cell in column B
like below
DC-1
DC-1
DC-2
DC-2
DC-4
DC-4
DC-4
DC-4
10024
Need only VBA. Not Formula
If you are happy with a formula use this then copy and paste the results a values back into column A
=SUBSTITUTE(A1," ","")
Happy with my advice? Click on the * reputation button below
But... if you really want VBA
then try this
Change the 1000 to the number of lines you need to do
Please Login or Register to view this content.
Last edited by Crooza; 08-16-2016 at 05:18 AM.
Please Login or Register to view this content.
.. and don't forget to have fun!
Bogdan.
mark SOLVED andAdd Reputation if my answer pleases you
Try this:
Please Login or Register to view this content.
Hi,
Only one line should be enough
You can achieve the same with the Replace dialogue very quickly as well.Please Login or Register to view this content.
Don
Please remember to mark your thread 'Solved' when appropriate.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks