# Google Sheets UNICHAR Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/unichar-function - Author: Better Analyst Formula Bot is now Better Analyst—same account, more powerful analysis.Formula Bot is now Better Analyst—same account and workflows, with more powerful analysis, dashboards, and automation. [Learn what changed](https://betteranalyst.com/formula-bot-is-now-better-analyst) The UNICHAR function returns the Unicode character that corresponds to a specified numeric code, enabling the display of special symbols. ``` UNICHAR(number) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the UNICHAR you need in plain EnglishGenerate Formula ## Parameters **`number`**:\ A numeric value between 0 and 1114111 that represents the Unicode code point of the character you want to return. ## What is the UNICHAR Function? The *UNICHAR* function in Google Sheets is a useful tool that allows users to return the Unicode character that corresponds to a specified numeric code. This function is particularly handy when you want to insert special characters, symbols, or emojis into your spreadsheet without having to copy and paste them from other sources. In simpler terms, UNICHAR enables you to create visually appealing spreadsheets by incorporating a wide range of characters simply by referencing their Unicode values. ## A Practical Example Imagine you are creating a feedback form and want to include star ratings using Unicode characters: ### Ratings Table: | RatingID | StarRating | | - | - | | 1 | 1 | | 2 | 3 | | 3 | 5 | You want to display the star ratings as actual star symbols instead of numbers. ## UNICHAR Formula To achieve this, you would use the UNICHAR function as follows: ``` =REPT(UNICHAR(9733), B2) ``` In this formula: - `UNICHAR(9733)` returns the filled star character (★). - `B2` is the cell containing the numeric rating. - `REPT` is used to repeat the star character based on the value in `B2`. ## Result of the Formula When you apply the UNICHAR formula to the Ratings Table, the output would look like this: | RatingID | StarRating | StarDisplay | | - | - | - | | 1 | 1 | ★ | | 2 | 3 | ★★★ | | 3 | 5 | ★★★★★ | In this case, the star ratings are visually represented by the actual star symbols, making the feedback form more engaging. ## Why Use UNICHAR? UNICHAR is beneficial because it allows for the easy inclusion of special characters and symbols in your spreadsheets. This can enhance the visual appeal of your data, making it easier to interpret and more enjoyable to interact with. Additionally, it can save time by eliminating the need to search for and copy special characters from other sources. ## Key Takeaways: - **UNICHAR**: A Google Sheets function that returns the Unicode character corresponding to a specified numeric code. - **Visual Appeal**: Enables the use of special characters, symbols, and emojis to enhance spreadsheet presentation. - **Efficiency**: Saves time by allowing users to generate characters directly within the formula. - **Common Use Cases**: Ideal for creating visual ratings, icons, and any scenario where special characters can improve data representation. UNICHAR is an essential function for anyone looking to add a creative touch to their Google Sheets, making data more visually appealing and easier to understand. Happy spreadsheeting! ## Example use case You have a table where Column A lists product codes and Column B contains their corresponding emojis. You can use the UNICHAR formula to display the emoji for a specific product code, enhancing visual appeal and making the data more engaging for presentations. ## Need more help with Google Sheets formulas? Sign up for Better Analyst and get unlimited AI-powered formula generation, explanations, and advanced data analysis. [Create Free Account](https://betteranalyst.com/signup)[Try Formula Generator](https://betteranalyst.com/excel-ai) ## Google Sheets how-to guides - [How To Filter In Google Sheets](https://betteranalyst.com/google-sheets/how-to-filter-in-google-sheets) - [How To Find Circular References In Google Sheets](https://betteranalyst.com/google-sheets/how-to-find-circular-references-in-google-sheets) - [How To Find Duplicates In Google Sheets](https://betteranalyst.com/google-sheets/how-to-find-duplicates-in-google-sheets) - [How To Freeze A Row In Google Sheets](https://betteranalyst.com/google-sheets/how-to-freeze-a-row-in-google-sheets) - [How To Freeze Panes In Google Sheets](https://betteranalyst.com/google-sheets/how-to-freeze-panes-in-google-sheets) - [How To Highlight Duplicates In Google Sheets](https://betteranalyst.com/google-sheets/how-to-highlight-duplicates-in-google-sheets) - [How To Insert Checkbox In Google Sheets](https://betteranalyst.com/google-sheets/how-to-insert-checkbox-in-google-sheets) - [How To Insert Multiple Rows In Google Sheets](https://betteranalyst.com/google-sheets/how-to-insert-multiple-rows-in-google-sheets) ## Explore all Google Sheets formulas Browse our complete library of Google Sheets formula guides Compare your options ## Decide with evidence, not a sales pitch. Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose. 1. [01ChatGPTOpen a balanced comparison prompt in ChatGPT.](https://chatgpt.com/?prompt=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 2. [02ClaudeOpen the same research prompt in Claude.](https://claude.ai/new?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 3. [03PerplexityResearch the comparison with linked web sources.](https://www.perplexity.ai/search?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.