Removing spaces at the end of a name

[PatrickSD]

I have downloaded some data that includes a list of names.
I want to vlookup the names, but the download has put a space after the last letter in the name.
Is there a formula that I can use to eliminate this space after the last letter in the name in each cell.

Thanks for any help.

 

[Mr_Roscoe]

Patrick - if the data is in column A, then create a formula in column B for example:

=TRIM(A1)

this will remove leading and trailing spaces

then you can copy/paste as values to convert it from a formula into text.

cheers, Ian R.

 

[PatrickSD]

Patrick - if the data is in column A, then create a formula in column B for example:

=TRIM(A1)

this will remove leading and trailing spaces

then you can copy/paste as values to convert it from a formula into text.

cheers, Ian R.

Ian, thank you.
That is exactly what I needed. I couldn't remember the formula
I really appreciate your help.