Is there a command which will delete blank spaces in a cell after the text has finished? for example, if the text in the cell is "Test Data ", I would like it to become "Test Data" (deleting the blank spaces to the right of the text), cheers.
Is there any way you can use a command with trim to apply it to the whole worksheet, rather than recording a macro which adds a column with the trim, copying PasteSpecial-values, for each column, cheers.
Yep that's perfect - many thanks for the link. Here is the code for anyone looking this up in a search:
Dim WorkRange As Range
Set WorkRange = Range("A1:I65536")
For Each Cell In WorkRange
If Cell.Value = "" Then
Cell.Value = Trim(Cell.Value)