Excel Formula Library

Ready-to-use Excel formulas with step-by-step explanations. Copy, paste, and customize for your needs.

💡 Need a custom formula? Try our AI Formula Generator for instant solutions!

20
Ready-to-Use Formulas
1
Categories
100%
Free & No Signup

Text Manipulation

Excel Formula to Extract Email Address from Text

Intermediate

I have a cell containing text and an email address (e.g., 'Contact john@example.com for info'). I want to extract just the email.

=TEXTBEFORE(TEXTAFTER(A1, " "), " ")
View Solution →3 steps

How to Remove Extra Spaces in Excel

Beginner

My data has weird spacing issues (spaces at the start or end). How do I clean it up?

=TRIM(A1)
View Solution →2 steps

Excel Formula to Count Words in a Cell

Intermediate

I need to know how many words are in a specific sentence in cell A1.

=LEN(TRIM(A1))-LEN(SUBSTITUTE(A1," ",""))+1
View Solution →3 steps

How to Capitalize the First Letter of Each Word

Beginner

My list of names is all lowercase (e.g., 'john doe'). I want to make them 'John Doe'.

=PROPER(A1)
View Solution →2 steps

Extract the First Word from a Cell in Excel

Beginner

I want to pull just the first name from a full name string.

=LEFT(A1, SEARCH(" ", A1) - 1)
View Solution →2 steps

Extract the Last Word from a Text String

Intermediate

I need to extract the last word from a sentence or name.

=TEXTAFTER(A1, " ", -1)
View Solution →2 steps

How to Remove Line Breaks in Excel

Beginner

I copied data from a website and it has weird line breaks inside the cells.

=CLEAN(A1)
View Solution →2 steps

Combine Multiple Cells with a Comma

Intermediate

I want to combine values from A1, B1, and C1 into one cell, separated by commas.

=TEXTJOIN(", ", TRUE, A1:C1)
View Solution →3 steps

Extract Domain Name from URL in Excel

Intermediate

I have a list of full URLs (https://www.google.com/search). I just want 'google.com'.

=TEXTBEFORE(TEXTAFTER(A1, "//"), "/")
View Solution →2 steps

Check If Cell Contains Specific Text (Case Insensitive)

Intermediate

I want to flag rows that contain the word 'Error' anywhere in the text.

=ISNUMBER(SEARCH("Error", A1))
View Solution →2 steps

Split Text by Delimiter into New Rows

Advanced

I have 'Apple, Banana, Orange' in one cell. I want them in 3 separate rows.

=TEXTSPLIT(A1, , ", ")
View Solution →2 steps

Remove the First Character from a String

Beginner

My data has a leading symbol (like '#102'). I want to remove the '#'.

=RIGHT(A1, LEN(A1)-1)
View Solution →3 steps

Remove the Last Character from a String

Beginner

I want to remove the last digit from a serial number.

=LEFT(A1, LEN(A1)-1)
View Solution →3 steps

Pad Numbers with Leading Zeros

Beginner

My product IDs need to be 3 digits long (e.g., 001, 010).

=TEXT(A1, "000")
View Solution →2 steps

Extract Text Between Parentheses

Intermediate

I want to get the SKU code from 'Product Name (SKU123)'.

=TEXTBETWEEN(A1, "(", ")")
View Solution →2 steps

Convert Text String to Date Format

Intermediate

My dates are not recognized by Excel. They are just text strings.

=DATEVALUE(SUBSTITUTE(A1, ".", "/"))
View Solution →2 steps

Replace Part of a Text String

Beginner

I need to change all instances of 'OldCompany' to 'NewCompany' in a column.

=SUBSTITUTE(A1, "OldCompany", "NewCompany")
View Solution →2 steps

Repeat Text Multiple Times

Beginner

I want to create a simple in-cell bar chart by repeating the pipe symbol '|'.

=REPT("|", B1)
View Solution →2 steps

Count Occurrences of a Specific Character

Advanced

I want to count how many commas are in a cell.

=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))
View Solution →2 steps

Generate Random Alphanumeric String

Advanced

I need a random 6-character code for user IDs.

=TEXTJOIN("",,CHAR(RANDARRAY(6,,65,90,TRUE)))
View Solution →3 steps

Need a Custom Formula?

Can't find what you're looking for? Our AI-powered formula generator can create custom Excel formulas based on your specific needs.

Try AI Formula Generator