You can use the "replace" command.

Select the fields that you want to perform this operation on
Edit (on the toolbar)
Select "Replace"
put a space in the find field
put nothing in the replace field

Let me know if this is unclear



"dcaissie" wrote:

I have an Excel spreadsheet of names, addresses, etc. that I need to use in a
mail merge to create labels. Several of the columns contain data with
trailing spaces. I know how to use the TRIM command to remove trailing
spaces one cell at a time, but is there a way to remove trailing spaces from
multiple cells at once? There are 4 contiguous columns of 133 rows
containing text with trailing spaces, and I don't relish removing those
spaces one cell at a time.