Removing spaces

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

Select the whole worksheet, CTRL + F (Find) space (space bar) and replace with none.

you can try this:
select column you want to change
ctrl+h and there you can type what you want to change and what you want instead
the only problem is that this remove all the spaces in each cell, not sure if you want this

Hi David,

Try and see if this works.

Assume your data is in "spaced_data" tab. Create a empty work sheet, name as "trim_data". In "trim_data"sheet, in cell "a1" type

=trim(spaced_data!a1) and drag for cell range as much as the range you have values in the "spaced_data".

Now copy all the cells in "trim_data" tab and paste as values in the "trim_data" sheet itself or in a new sheet. Now, You should have "all end space" removed data.

Hope this works..

thank you very muchos

you can use trim