Non-Printing Characters: Box with a Question Mark Unable to remove

[New_Here]

MYClean is used like a normal function. It is added to a code module in the workbook. If you don't use VBA, you'll need to add the Developer tab to the ribbon to access it. You can rename it if you want.

Wowwwww ! You are a genius aren't you?

Ok, I checked the attached worksheet and understood what you tried to achieve by the first micro,

What was the second part for? what exactly does it do and how do I use it in the same WORKBOOK?

Because, in the workbook which was attached, I found only the 1st part of your equation was mentioned in the module,

the part you said,

"I made up this to determine the character which was copied into another cell."

you haven't added that.

Why and what exactly does that coding do? Please apologize this Newbie