Nanette,
I'm not sure I understand the problem you are describing. If text in your
cells have unnecessary leading and trailing spaces why not just use trim()
in the VBA module that generates the Unix scripts? Again, maybe I don't
understand your explanation.

"Nanette" wrote in message
...
I'm trying to use excel to create some simple unix scripts. When ever I
set
up my data in excel I use copy and paste to put it into a text document.
Doing this introduces unnecessary spaces that I end up manually removing.
Any suggestions?