Remove leading and trailing spaces in a cell?

Hello,

I cannot find an answer to this specific question. Does anyone know an easy way to remove all spaces from a cell, both leading and trailing? I find it hard to believe that Excel doesn't have this functionality. I don't particulary want to write a VBA script since I have never done it but if that's the only way, I'd love to know how to write it. I have looked everywhere but obviously not in the right places. Any help would be greatly appreciated!

There is a function, TRIM(), which removes leading and trailing spaces, and also multiple spaces between words, so you just need to use:

=TRIM(A1)

in a helper column to remove the excess spaces from cell A1. Copy it across and down, as required to remove them from other cells. You can then fix the values in those cells, using Copy | Paste Special | Values | OK and then press the <Esc> key, and then you can paste them over the original values and delete the helper columns.

Hope this helps.

Pete

Thank you so much! Your help is very much appreciated. I saw that function but my attempts to use it failed. Now I know!