Text functions

The Text Functions category covers essential Excel functions for manipulating and analyzing text data. Learn how to extract, format, split, and clean text using LEFT, RIGHT, MID, TEXT, CONCAT, TEXTJOIN, FIND, SEARCH, and more. Whether you’re working with names, addresses, or structured data, these functions help automate text processing and improve data accuracy. Explore our tutorials, examples, and tips to master text handling in Excel!

Keep Your Date Format When Joining Text in Excel

Joining a date to text in Excel gives a number like 46309. Wrap the date in the TEXT function to keep its format, and avoid the language trap.

CONCAT vs CONCATENATE in Excel: What Actually Changed

CONCAT accepts a whole range, CONCATENATE needs every cell one by one. See what changed, which one to use, and the Excel version trap.

Build Email Addresses from First and Last Name in Excel

Build firstname.lastname@company.com for a whole staff list with one Excel formula, the short version with LEFT, or Flash Fill with no formula at all.

Excel LEN Function Explained

Learn how to use the LEN function in Excel to count characters in a string, data validation, and conditional formatting.

Capitalize the first letter in Excel (Camel Case)

Find out how to capitalize the first letter in Excel using three powerful tools: PROPER function, Power Query, and macros.

Title with Text and Date in the same cell

Learn how to use the TEXT function in Excel to format numbers and keep the desired number format inside a string.

Text functions

Categories

Text functions