Lists Text functions, such as the Clean, Proper, and Trim functions.| support.microsoft.com
Syntax: TEXT(value, format_text)| support.microsoft.com
The CONCAT function combines the text from multiple ranges and/or strings, but it doesn't provide delimiter or IgnoreEmpty arguments.| support.microsoft.com
Operators specify the type of calculation that you want to perform on elements in a formula—such as addition, subtraction, multiplication, or division. There are four different types of calculation operators: arithmetic, comparison, text concatenation, and reference.| support.microsoft.com