I have spreadsheets that contain columns of text, numbers, function of those numbers, etc. I would like to develop a macro that will search the spreadsheet for any cells that contain text and trim the string within. I've found macros already written that trim all cells in a spreadsheet, but they change cells using formulas to value only. I need to keep the formulas active. Here is a macro I found in a forum that trims a column of text but you have to define the column and range each time:
I don't have enough vba knowledge yet to simply make the macro apply to any one text column by just highlighting a range, OR enough know-how to tell the macro to go from one column to the next to search for text to trim. Please let me know how to edit it to achieve my goals. Thank you!Please Login or Register to view this content.
Bookmarks