In following your instructions I encountered the following:
- I entered the formula as shown without the quotes around Sheet1
- I copied this formula accross the area (cells/rows) where I'll paste
- When I click on Insert Menu I don't see the Paste SPecial option
- if I do a right click on the area selected that has my data I get
the Insert Menu and select Past SPecial, and Values

Here is what I get:
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?

the formula looks like this: =TRIM(ALL!A1) All = spreadsheet  name
Thank you for your assistance and time.