Spaces spaces and more spaces

[bobgrand]

Hello all,

I have a text file that gets imported into excel that is + separated. Most of the columns have many spaces at the end of them. I can't use the space separator during the import because it will break up areas of descriptions. I would love to hear your thoughts on how I can get rid of the many spaces at the end. Ex. Quote# 19112558-22 has 12 extra spaces at the end of it. 19112558-22____________.

There is probably a simple way that is just not clicking with me at the moment.

Any help would be greatly appreciated.

Bob

 

[Eric W]

Use a TRIM function on the cell with the data.