'loop will check each character within sInput to see if it matches any character within the sSpecialChars string 'For loop will repeat equal to the length of the sSpecialChars string Here is the function in it's current state: Function findInvisChar(sInput As String) As String The functions does not bother to locate every one of the 32 ASCII control characters, it only fines the one which don't have a graphical representation in Excel. The UDF then creates a message box telling the user what character has been found and removed. Alright, I have created (with the best help from StackOverflow) a User Defined Function, which Identifies specific (invisible), non-printable control characters within a given cell.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |