My apologies if this has been posted already but I have not been able to find a thread like this yet.
At the office we use a third party program that we can export data into excel (csv) format which we then copy into a worksheet "machine" of sorts. They have recently changed the format of one of the columns in the export. In column D starting on row 3 are values with a space at the end. These values are "general" format, so how the space is present after a number is beyond me. The values in column D contain both numbers and letters (examples: 602, 677A, ....) there are also three digit single numbers (002) that can be displayed as 2 when we are done. Also the number of entries in column D can vary. May be 100s or 1,000's of lines. The current project has 4850+.
What I am looking for is a macro that will remove the space from the end of the values in D and leave them as a general format. If the 002 returns to 2 it will be alright.
I imagine it is pretty simple but I am far from a macro/vba guru.
As an updated note I did try to just find and replace a space with nothing but, excel was unable to find a "space" at the end, even tho if you use the len() function on a cell showing 602, the formula will return 4.
Any help will be much appreciated!