I understand the TRIM function in excel removes spaces from the end and beginning of strings, but is there some way to change the settings of a workbook so that this is done to every cell, I have an entire data book with filthy spaces at the end of texts and its in such a dotted about manner that trimming everything would be gloriously impractical,

I expect no is the answer unfortunately, but thanks all the same