Removing trailing spaces from cells ?

[Ian]

Is there a way of removing all the trailing spaces from cells?

i.e Henry James<space><space><space> becomes Henry James

and

John<space><space><space><space><space> etc becomes John.

Thanks in advance.

 

[Don Guillett]

Have a look at TRIM

 

[Ian]

Have a look at TRIM

Thanks !

 

[Don Guillett]

glad to help