I have a spreadsheet with multiple columns. Several of the columns for some reason or another ended up with spaces before the numbers or dates in 4 of the columns. This, in turn, prevents the file from being uploaded properly. Is there a VBA script that can be run to automatically remove any extra spaces that exist in any column?
attach please a small sample file with also desired result
If solved remember to mark Thread as solved
Hi kre30a, try the following but amend it to your needs
Please Login or Register to view this content.
If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.
---Keep on Coding in the Free World---
Common Courtesy Response
Did this help your problem? It's been noted that you have returned since the last post but haven't managed to let us know if your issue is resolved. As a matter of courtesy perhaps you'd like to respond to those that have taken time out of their day to help you for free?
I'm sure you can see that you're more likely to receive help a second time if you are remembered as someone who has offered thanks in the past. That's just human nature.
Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks