Learn about 10 Text functions in Excel with examples, including Find, Len, Left, Right, Mid, Substitute, Upper, Trim, Concatenate, and Text.

A Text function changes how a number appears by applying the format to it with format codes; an example of a Text function is the T function.

The UPPER () function returns text in all uppercase letters. CONCATENATE () combines multiple text strings together as a single string, as the following example shows: ...

For example, below in cell A4, I have used the Concatenate symbol (the “&” symbol) to combine both text and numbers. I also used the Text function to control the formatting of the values included in ...

Use the RANDARRAY() dynamic array function to return random names or other text in Microsoft Excel.

If you have Excel 2019 or Excel 365, you can use the function TEXTJOIN to quickly join text in one cell and separate the text with any delimiter, even if you have many rows or columns of data to join.

If you want to master functional programming, the best place to start is with the Java Function interface. This example will show you four different ways to implement this functional interface in your ...