![]() There are many alternative methods, especially once you start considering VBA, but the key is in being able to figure out what the mystery character is to begin with.īuilding on the other answers, here's how I quickly found the rouge character. UNICODE and UNICHAR can theoretically be replaced by CODE and CHAR, but in a quick test that I just performed with ♪, I couldn't get them to work. Where x is the code determined in step one, y is what you want to replace it with, and A1 is the location of your problem cell. Step 2: Substitute the mystery character with a visible character, or delete it entirely using: =SUBSTITUTE(A1,UNICHAR(x),"y") You will notice characters that are ( example). Tip: Convert the font to Webdings to clearly see all the characters. If you get a #NAME? error, remember to put quotes around the mystery character since it should be entered as a string. =UNICODE() used on a single character will give you this code. Step 1: Determine the character code of the mystery character. This question and the answers above (or below) guided me through solving a problem I had, so I wanted to throw some upvotes and summarize in it's entirety an answer to the OP's original question: Still it shows 10 characters, instead of 9. ![]()
0 Comments
Leave a Reply. |