If you want to apply it to the entire spreadsheet try this...

On a clean spreadsheet select cell A1.

Type the following into the cell: "=Trim("

Then switch back to the original sheet and click on Cell A1 and hit Enter.

Now you have an entry in cell A1 of your new sheet that does not have any
trailing spaces. Copy and paste the cell into the new sheet over the same
range as the original sheet. You should now have a sheet that looks the same
as your original sheet.

One more step... Click the gray box on the top left side of the new sheet
to select the entire sheet. Use edit... copy to copy the contents of the
sheet to the clipboard. Then, use edit... paste special... select values
from the pop-up box, click on O.K. to paste the cells back into the sheet as
plain text instead of formulas.

Regards...







"Kamran" wrote:

Sorry, I'm not that advanced -- where do I put that?