This Excel tutorial explains how to use the Excel CODE function with syntax and examples.
The Microsoft Excel CODE function returns the ASCII value of a character or the first character in a cell.
The syntax for the CODE function in Microsoft Excel is:
CODE( text )
The CODE function can be used in the following versions of Microsoft Excel:
The CODE function can be used in Microsoft Excel as the following type of function:
Let's look at some Excel CODE function examples and explore how to use the CODE function as a worksheet function in Microsoft Excel:
Based on the Excel spreadsheet above, the following CODE examples would return:
=CODE(A1) Result: 116 =CODE(A2) Result: 84 =CODE(A3) Result: 84 =CODE("www.techonthenet.com") Result: 119
(scroll to see more)