VALUE Function – Google Sheets
Learn how the VALUE function converts text to a number.
Text
CONCATENATE Function – Google Sheets
The CONCATENATE function in Google Sheets combines text strings. Syntax =CONCATENATE(string1, [string2, …]) Similar Functions CONCAT – Join two text strings JOIN – Concatenate parts of an array with a delimiter Examples Here are three examples of how to use this function: Example 1 – Two Text Strings =CONCATENATE(“Hello, “, “world!”) This formula will combine … Read more
UNICHAR Function – Google Sheets
Learn how to use the UNICHAR function to use Unicode characters in Google Sheets.
UNICODE Function – Google Sheets
Learn how to use the UNICODE function to find the Unicode character code.
CODE Function – Google Sheets
Learn how to use the CODE function to find the Unicode number of the first letter in a text string.