Google Sheets UNICODE Function

What Is Google Sheets UNICODE Function ?

UNICODE function in google sheets returns Unicode code value or the first character’s equivalent number in the text. The google sheets UNICODE function is categorized under TEXT functions.

For example, consider the below text string showing ‘Google Sheets Formula’ in cell A1.

Now, let us use google sheets UNICODE function to find the code or the value.

The steps are:

Step 1: To begin with, select the cell where we want to find the result. In this example, the cell is B1.

Step 2: Now, let us insert the UNICODE formula, =UNICODE(A1)

Step 3: Finally, press Enter key.

Now, we can find the result as shown in the below image.

Likewise, we can find UNICODE value using UNICODE function in google sheets.

In this article, let us learn how to use UNICODE function in google sheets with detailed examples.

UNICODE() Google Sheets Formula

UNICODE function is an inbuilt function.

The syntax is =UNICODE(text) where text denotes the cell reference used to find the UNICODE value or code. Remember, text is the only mandatory argument.

How To Use Google Sheets UNICODE Function?

We can use google sheets UNICODE function with ease.

Now, let us learn how to use google sheets UNICODE function with an example.

Consider the below table showing lowercase and uppercase letters in cell references A1 and A2 respectively.

The steps are:

Step 1: To begin with, select the cell where we want to find the result. In this example, the cell is B1.

Step 2: Now, let us insert the UNICODE formula, =UNICODE(A1)

Step 3: Finally, press Enter key.

Now, we can find the result as shown in the below image.

Next, using AutoFill option, we can find the result in cell B2 as shown in the below image.

Likewise, we can find the code using UNICODE function.

Examples

Now, let us learn how to use UNICODE function with detailed examples in this section.

Example #1

Consider the below table showing text in column A. We need to find the result, i.e., the code in column B.

Now, note that the text string in cell range A2:A4 is mixed. It is because, there are uppercase, sentence case and numeric values.

Let us learn how to use UNICODE function.

The steps are:

Step 1: To begin with, select the cell where we want to find the result. In this example, the cell is B2.

Step 2: Now, let us insert the UNICODE formula, =UNICODE(A2)

Step 3: Next, press Enter key.

Now, we can find the result as shown in the below image.

Now, using AutoFill option, we can find the result in cells B3 and B4 as shown in the below image.

As we can see, we can find the code or value using UNICODE function.

Example #2

Consider the below table showing text in column A. Now, we need to find the result, i.e., the unicode in column B.

Meanwhile, note that the text string in cell range A2:A8 is mixed. It is because, there are symbols, letters, and words.

Now, let us learn how to use UNICODE function.

The steps are:

Step 1: To begin with, select the cell where we want to find the result. In this example, the cell is B2.

Step 2: Now, let us insert the UNICODE formula, =UNICODE(A2)

Step 3: Next, press Enter key.

Now, we can find the result as shown in the below image.

Now, using AutoFill option, we can find the result in cells B3 and B4 as shown in the below image.

As we can see, the result (code or number equivalent) differs with symbols (emojis), words, and numeric values.

Likewise, we can use UNICODE function.

Example #3

Consider the below table showing text in column A. We need to find the result such that the Roman numbers are removed in column C.

We can do this using UNICODE function along with other functions like IF, LEFT, and SUBSTITUTE functions.

The steps are:

Step 1: To begin with, we need to select the cell where we want to find the result. In this example, the cell is B2.

Step 2: Now, let us insert the UNICODE formula, =UNICODE(A2)

Step 3: Next, press Enter key.

Now we can find the result as shown in the below image.

Now, using AutoFill option, we can find the result in cells B3 and B4 as shown in the below image.

Step 4: Now, let us first insert the IF function in cell C2.

Step 5: Next, we need to insert the UNICODE function as shown in the below image.

Step 6: Now, include the LEFT function and select cell A2 as the argument

Step 7: Now, close the parenthesis. Mark the Unicode value with greater than or equal to sign as shown in the below image.

Step 8: Now, similarly, enter the IF, UNICODE, LEFT functions with lesser than or equal to 8546 code value as shown in the below image.

Step 9: Now, using SUBSTITUTE function, we can remove the roman numbers. Insert the formula, SUBSTITUTE(A2,LEFT(A2),””)),A2.

So, the total formula is =IF(UNICODE(LEFT(A2))>=8544,IF(UNICODE(LEFT(A2))<=8546,SUBSTITUTE(A2,LEFT(A2),””)),A2)

Step 10: Finally, press Enter Key.

Now, we can see the result as shown in the below image.

Now, using AutoFill option, we can find the result in cells B3 and B4 as shown in the below image.

Likewise, we can find the desired result using UNICODE function.

Important Things To Note

1. Google sheets UNICODE function, in simple words, finds the code.
2. Google Sheets UNICODE function is an inbuilt function.
3. Categorized under the TEXT functions, this function is similar to the UNICODE function in Excel.

Frequently Asked Question(FAQs)

Recommended Articles

• Google Sheets IMPORTRANGE + AI: Cross-Sheet Mastery
• SUMXMY2 in Google Sheets
• TBILLPRICE in Google Sheets
• YIELDMAT in Google Sheets