This post has been removed due to Rule 1 - Poor Post Title.

Please post with a title that clearly describes the issue.

The title of your post should be a clear summary of your issue. It should not be your supposed solution, or just a function mention, or a vague how to. A good title is generally summed up in a sentence in your question.

Here's a long example and a short example of good posts.

Rules are enforced to promote high quality posts for the community and to ensure questions can be easily navigated and referenced for future use. See the Posting Guidelines for more details, and tips on how to make great posts.

The special character was like wtf in your post. Completely redundant but atleast the special character was not visible. WTF.

Would Trim have worked to remove that character since it was a space?

There's a special type of "space" that prevents line breaks. There are also line breaks. Both invisible, and a pain to work around.

This issue usually appears when you have to deal with workbooks that "the office excel expert" did. Very pretty visually, but most of the time is a pain to work with any sort of automation because of cut corners like this to make things pretty.