cheers,

but i would also like to use =PROPPER in my cell, as well as the =TRIM
Is this possible?

Regrads,

Chris



"Chris" wrote:

Ok, I just found that =TRIM(A2) works, but i also would like =PROPER(A2) to
be used as well, so that it Corrects the Name to the proper way of (example)
Chris and also deletes any unwatted spaces at the end?

Regards,

Chris



"Chris" wrote:

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