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 […]

How to use the CODE function

The CODE function returns a specific number for the first character of the text argument, determined by your computers character set. […]

Extract numbers from a value

Chirag asks: I want to separate numbers from following text: Abc123bx45 as a result 123 and 45 should be in […]

Exact word in string

I read an interesting blog post Is A Particular Word Contained In A Text String? on Spreadsheetpage. That inspired me […]