I have a spreadsheet with 30,932 rows. Column C has a ton of cells that have blank spaces at the end of the text which I would like to delete. I know that I need to include the Trim function but how do I setup the macro so that it goes from C1, to C2, to C3, to C4, etc?
This is what I have so far:
This is what I have so far:
Code:
Application.ActiveCell = Trim(Application.ActiveCell)