Hidden Characters?

  • Thread starter Thread starter GL
  • Start date Start date
G

GL

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.
 
Pl. send the file to me at (e-mail address removed)

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?
 
Back
Top