Sometimes you may need to convert character or text data to ASCII code value in MS Excel. There is a function called
CODE in MS Excel by which you can do this.
CODE function returns the ASCII code value of the leftmost character of a character or text expression. To know more about ASCII characters you can see the Printable
ASCII Characters section of my another post ASCII Characters.
Let’s see the function syntax:
In this syntax:
- Parameter text is an expression of any text data, cell reference or cell name.
- This function returns the ASCII code value of the leftmost character of the text expression.
The following example uses
CODE function to convert text to ASCII code value.
Here is the result set.
In this tutorial, I have shown you how to convert character or text data to ASCII code value in MS Excel. Hope you have enjoyed the tutorial. If you want to get updated, like my facebook page http://www.facebook.com/freetechtrainer and stay connected.