UNICHAR
Returns the unicode character associated with a number
Syntax:
UNICHAR(value)
UNICHAR checks value, returning the unicode character associated with value.
Example:
If A1 contains 65:
UNICHAR(A1)
returns A
A | B | ||
|---|---|---|---|
1 | 65 | A |
Application:
Creating a Star Rating System
Let's say you're a manager tracking employee performance and you want to visualize the ratings using a star system instead of just numbers. You can use the UNICHAR function to display a solid star for each point earned, up to a maximum of 5 stars. The Unicode for a solid black star is 9733.
Table: Employee Performance Ratings
Employee | Performance Rating (1-5) | ||
|---|---|---|---|
A | B | ||
1 | John Smith | 4 | |
2 | Jane Doe | 5 | |
3 | Peter Jones | 3 | |
4 | Mary Lee | 2 |
Formula
To create the "Star Rating" column, you would use the following formula in cell C1:
REPT(UNICHAR(9733), B1)
Explanation of the formula:
- UNICHAR(9733): This part of the formula returns the solid black star character (★).
- REPT(): This function repeats a given text a specified number of times.
- REPT(..., B1): This repeats the star character the number of times specified in cell B1 (the "Performance Rating").
Resulting Table
After applying the formula, the table would look like this:
Employee | Performance Rating (1-5) | Star Rating | ||
|---|---|---|---|---|
A | B | C | ||
1 | John Smith | 4 | ★★★★ | |
2 | Jane Doe | 5 | ★★★★★ | |
3 | Peter Jones | 3 | ★★★ | |
4 | Mary Lee | 2 | ★★ |
This example demonstrates how the UNICHAR function, combined with REPT, can create a visually appealing and easy-to-understand representation of data, which is a common need in real-world business and data analysis scenarios.
PRODUCT & FEATURES
RESOURCES
Terms | Privacy | Spam Policy
© 2026 Zapof
Application:
Creating a Star Rating System
Let's say you're a manager tracking employee performance and you want to visualize the ratings using a star system instead of just numbers. You can use the UNICHAR function to display a solid star for each point earned, up to a maximum of 5 stars. The Unicode for a solid black star is 9733.
Table: Employee Performance Ratings
Employee | Performance Rating (1-5) | Star Rating | |
|---|---|---|---|
John Smith | 4 | ★★★★ | |
Jane Doe | 5 | ★★★★★ | |
Peter Jones | 3 | ★★★ | |
Mary Lee | 2 | ★★ |