Archive for CODE function
How to remove unwanted characters in a cell
Cell B3 contains a few odd characters and the formula in C3 shows the ANSI equivalent of each character in […]
Identify all characters in a cell value
Sometimes when you sort values you get unexpected results, the cause is probably unwanted characters in a cell. The same […]
The CODE function returns a specific number for the first character of the text argument, determined by your computers character set. […]
Chirag asks: I want to separate numbers from following text: Abc123bx45 as a result 123 and 45 should be in […]
I read an interesting blog post Is A Particular Word Contained In A Text String? on Spreadsheetpage. That inspired me […]
