## Introduction

UNICHAR function are text/string function in excel. This function is used to find out Unicode character of a defined number. Unicode is in form of decimal numbers from 0 to 65535.This function was introduced in Excel 2013 and later versions. It is a worksheet function and can be entered in the cell of a worksheet.

## Syntax

*=UNICHAR( Number)*

## Arguments

Number: It is the number which will be used to find the Unicode character

## Keynotes

- Unicode character retrieved may also be a string of characters based on the initial number.
- If numbers used are partial and invalid data types are used than #N/A error is displayed.
- If number is zero or greater than the specified range #VALUE error is displayed.
- It is case sensitive and gives different results for uppercase and lowercase letters.

## Examples

In this example, some numbers are entered in column A an UNICHAR function is used to retrieve their corresponding Unicode characters as follows:

Unicode Number | Result |

80 | P |

113 | q |

67 | C |

91 | [ |

165 | ¥ |

Pingback: How to use Excel UNICODE Function - Excelhub