How do I remove the space in the end of each cell and get the data without space in the adjacent cell? I tried the trim function but the extra space is not removed in the result. I need your expert advise to know how to remove the extra space.
Please note: Not all the cells have extra space.
I even tried find and replace with space bar in find and blank in replace. But it did not work