Text Archives - Sheets Help

CONCATENATE Function – Google Sheets

September 17, 2023July 13, 2023 Adam Steinfurth

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

December 9, 2023May 30, 2023 Adam Steinfurth

Learn how to use the UNICHAR function to use Unicode characters in Google Sheets.

UNICODE Function – Google Sheets

January 31, 2024May 26, 2023 Adam Steinfurth

Learn how to use the UNICODE function to find the Unicode character code.

CODE Function – Google Sheets

December 9, 2023May 17, 2023 Adam Steinfurth

Learn how to use the CODE function to find the Unicode number of the first letter in a text string.

CHAR Function – Google Sheets

December 9, 2023May 15, 2023 Adam Steinfurth

Learn how to use the CHAR function in Google Sheets.