Tidy up cell data with a space at the end

[wallyxl]

Hi everyone,
I have seen this on a Mr Excel video but cannot find it.
I have a table of data with names in each cell, the problem is that sometimes the name is R Rabbit and other times it is R Rabbit with a space behind the T. Excel now treats this as two differant strings. How can I remove any blank space from the end of the names that contain the space?

Cheers
Wally

 

[Joe4]

Use the TRIM function.

 

[wallyxl]

Thanks Joe4, all good now.

 

[Joe4]

You are welcome.