Remove the spaces in the last string

Hi All,
I got a excel file that has this annoying empty spaces at the end of string. How do I remove it as not all strings are ended with empty spaces? For instance, cell A1 is abc__ and A2 is xyz and A3 is ijk_. The empty spaces deter my Vlookup working correctly, thanks for any tips and guidance.

Try using Data--> Text To Columns --> Fixed

This will allow you to move around what's in each cell, i.e. moving the annoying end part into another column.

Best of luck!

Wow, thank you. I will try it out shortly, thanks again.

You can also use =trim(a1) in col B and extend as needed.
Trim will remove all space except spaces within the string