Removing trailing spaces from cells ?

I

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data cleanup 1
End/Beginning of Cell Search/Replace? 1
Trim Characters Other Than An Empty Space At The End Of A Cell 5
Check for leading or trailing spaces 2
trim cells with space in betwen numbers in cell 2
Remove trailing spaces from multiple columns in Excel 8
Excel Subtract text after the third space and before the fourth (from between spaces) 3
Access Access anti-trim?? 0

Top