Get Character Number With Excel CODE Function
returns a numeric code for the first character in a text string.
For Windows, the returned code is from the ANSI character set, and for Macintosh, the code is from the Macintosh character set. .
The CODE function can help unravel mysteries in your data, such as:
-- What hidden character is at the end of imported text?
-- How can I type a special symbol in a cell?
Watch this video to see how to use the Excel CODE function, and return a numeric code.
Get the sample Excel file on my Contextures site:
https://www.contextures.com/excelcode...