I forgot to mention:

If I just put an example in excel with spaces then the text then spaces and
test with Trim(CellAddress) then it will trim properly.

This was something taken off the internet. I have see in other posts where
you have to test the characters but I have not been able to make those work.
It is the leading spaces that seem to cause the problem.

Steven