ExcelBanter - View Single Post

Sheeloo

Pl. send the file to me at

Have you checked the formatting of the cell?
What about Len of the cell? Is is the same as the no of characters or is it
more than that?
What about RIGHT(cell,1) and then using CODE on that?

"GL" wrote:

I have downloaded a file in Excel format and it appears that there are 2
extra spaces at the end of each cell. However, when I tried to replace the
spaces using a macro, it only removed one of them. I have tried using the
TRIM function, but that isn't working. And when I use the CONCATENATE
function, it puts them together as if there weren't a space.

Could there be a hidden character? How do I "fix" this.

Any ideas, this is driving me bonkers.