Master Excel Text Formulas

Learn to manipulate text in Excel with powerful formulas like CONCATENATE, LEFT, RIGHT, MID, and more. Complete guide with practical examples.

Try AutoExel Free See Examples

What are Text Formulas in Excel?

Excel text formulas allow you to manipulate, concatenate, extract, and transform text strings. These formulas are essential for cleaning data, creating labels, and automating text operations.

The main text formulas include CONCATENATE (or &), LEFT, RIGHT, MID, UPPER, LOWER, PROPER, LEN, TRIM, SUBSTITUTE, and FIND.

Main Text Formulas

CONCATENATE / &

Joins multiple text strings into one

=CONCATENATE(A1, " ", B1)
=A1 & " " & B1

Example: A1="John", B1="Smith" → Result: "John Smith"

LEFT

Extracts characters from the left of a text

=LEFT(A1, 3)

Example: A1="Excel2024" → Result: "Exc"

RIGHT

Extracts characters from the right of a text

=RIGHT(A1, 4)

Example: A1="Excel2024" → Result: "2024"

MID

Extracts characters from the middle of a text

=MID(A1, 6, 4)

Example: A1="Excel2024" → Result: "2024"

UPPER / LOWER

Converts text to uppercase or lowercase

=UPPER(A1)
=LOWER(A1)

Example: A1="John" → UPPER: "JOHN", LOWER: "john"

TRIM

Removes extra spaces from text

=TRIM(A1)

Example: A1=" Excel " → Result: "Excel"

Practical Examples

Create Email from First and Last Name

=LOWER(A1 & "." & B1 & "@company.com")

A1="John", B1="Smith" → Result: "john.smith@company.com"

Extract Year from Date Text

=RIGHT(A1, 4)

A1="12/31/2024" → Result: "2024"

Clean and Format Names

=PROPER(TRIM(A1))

A1=" jOhn SmIth " → Result: "John Smith"

Tired of Manual Text Formulas?

AutoExel analyzes your text data and automatically applies the right formulas. Save hours of work!

Try AutoExel Free

Frequently Asked Questions

What's the difference between CONCATENATE and &?

They do the same thing: join texts. The & operator is faster to write. For Excel 2016+, use CONCAT or TEXTJOIN for more options.

How do I remove non-printable characters?

Use the CLEAN function: =CLEAN(A1) removes all non-printable characters from the text.

Can I split text into multiple columns?

Yes! Use "Text to Columns" (Data tab) or formulas like LEFT, MID, RIGHT combined with FIND to locate separators (spaces, commas, etc.).