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.