Hi Everybody,
I regularly work on large amount of data in excel for which I do the clean up everytime.
I generally use Clean,Trim and Proper functions.
Could someone please help me out with a macro which should do all the three activities with a click of button.
For Example If Column A has data for first ten thousand rows and when I select the data and run the macro all the three functions should work on that and moreover then same action is done on column B it should work Vice versa.
Bookmarks