If you do this on a regular basis it's probably better to use a macro


http://www.mvps.org/dmcritchie/excel/join.htm#trimall



how to install a macro



http://www.mvps.org/dmcritchie/excel/install.htm



now all you have to do is to select the imported range and run the macro



--


Regards,


Peo Sjoblom


"Chris" wrote in message
...
Hi All,

Just wondering if it is possible to remove any SPACES/GAPS after text in
cells?
As I recieve data daily somtimes has gaps at the end of the text.

This text gets copyed and pasted into another spredsheet where a script is
run, but if there are any gaps after the text, the script fails.

Any help would be great,

Regards,
Chris