LinkBack URL
About LinkBacks
Looking for a macro that will remove all leading spaces for a sheet.
Thanks so much in advance!
Looking for a macro that will remove all leading spaces for a sheet.
Thanks so much in advance!
That could be very slow.
This will work for column A
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Please Login or Register to view this content.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Last edited by mehmetcik; 03-29-2018 at 06:01 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
understood, my exact range would be J3:W100
Please Login or Register to view this content.
Last edited by mehmetcik; 03-31-2018 at 03:34 PM.
tryOriginally Posted by hftechno
Please Login or Register to view this content.
I tried both with no success. Attached is an example as requested. All non-zero values in the shaded area have a leading space.
Hi hftechno,
maybe so
Please Login or Register to view this content.
That worked!
Very clean and simple.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks