Hi,
I need a macro for excel 2003 that allows me to trim whitespace before/after the cell content and asign the cell range. I've tried a few off google search but with no luck. Is there anyone who has a code that will work in both Excel 2003 and Excel 2010? I searched the forums too and haven't had any luck finding anything.
the first part I get, but what do you mean by "...and asign the cell range..."?
If you like my contribution click the star icon!
attach a sample file with current table and derised result
If solved remember to mark Thread as solved
Not quite sure what you mean. Can you give a specific example.
Do you really need a macro. The obvious function is =TRIM(A1") does that work for you?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi OllieB,
I need a macro that will trim A1:P500. I'd like to asign the range that the macro trims so it isn't trimming the entire sheet.
I need a macro for this to run with a few othere macros.
Maybe this can help?
http://www.excelfox.com/forum/f13/tr...sheet-vba-155/
Heres a couple ways. Second option would be faster
Please Login or Register to view this content.
Last edited by mike7952; 01-10-2013 at 10:38 AM.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
So many experts helping out, what a great forum!
John,Originally Posted by JOHN H. DAVIS
I gave it a try, and wiped out the database file by adding 0 to most of the cells that had content in it. So I closed it without saving.
I'll take the prize behind door #2. That did the trick. Thanks for all the replies.
Last edited by smugglersblues; 01-10-2013 at 11:01 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks