Text Formulas
Learn Excel text manipulation formulas including CONCATENATE, TEXTJOIN, LEFT, RIGHT, MID, TRIM, and more. Master string operations and text extraction.
Functions in this Category
Common Use Cases
1
Combining text from multiple cells
Generate formula for this →2
Extracting parts of text strings
Generate formula for this →3
Cleaning and formatting text data
Generate formula for this →4
Converting numbers to formatted text
Generate formula for this →5
Finding and replacing text patterns
Generate formula for this →Detailed Function Guides
CONCATENATE
Learn to combine text in Excel using CONCATENATE, TEXTJOIN, and the & operator. Join cells with delimiters and handle empty cells....
CONCATENATE(text1, [text2], ...) or TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)
Example:
=CONCATENATE(A1, " ", B1)Join A1 and B1 with a space
Related Formula Categories
Need a Custom Text Formula?
Describe your calculation in plain English and our AI will generate the perfect formula for you.
Try Formula Generator Free