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

An Example of the Transactional Type Functions in a Business. Strategic business functions, such as accounting, marketing and product development, are dedicated to planning, strategy and analysis.

I'll run through three logical functions (or groups of functions) that I find particularly helpful, and how you can also make the most of them in real-world scenarios.