Okay, I did the first part, but that's only cell A1. The second part just
sounds like a Paste Special Values operation, but I don't see how to
incorporate the TRIM function into it. So I still need help with applying it
to the whole sheet.


"ChristopherTri" wrote:

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?