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!
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, " "), " ")My data has weird spacing issues (spaces at the start or end). How do I clean it up?
=TRIM(A1)I need to know how many words are in a specific sentence in cell A1.
=LEN(TRIM(A1))-LEN(SUBSTITUTE(A1," ",""))+1My list of names is all lowercase (e.g., 'john doe'). I want to make them 'John Doe'.
=PROPER(A1)I want to pull just the first name from a full name string.
=LEFT(A1, SEARCH(" ", A1) - 1)I need to extract the last word from a sentence or name.
=TEXTAFTER(A1, " ", -1)I copied data from a website and it has weird line breaks inside the cells.
=CLEAN(A1)I want to combine values from A1, B1, and C1 into one cell, separated by commas.
=TEXTJOIN(", ", TRUE, A1:C1)I have a list of full URLs (https://www.google.com/search). I just want 'google.com'.
=TEXTBEFORE(TEXTAFTER(A1, "//"), "/")I want to flag rows that contain the word 'Error' anywhere in the text.
=ISNUMBER(SEARCH("Error", A1))I have 'Apple, Banana, Orange' in one cell. I want them in 3 separate rows.
=TEXTSPLIT(A1, , ", ")My data has a leading symbol (like '#102'). I want to remove the '#'.
=RIGHT(A1, LEN(A1)-1)I want to remove the last digit from a serial number.
=LEFT(A1, LEN(A1)-1)My product IDs need to be 3 digits long (e.g., 001, 010).
=TEXT(A1, "000")I want to get the SKU code from 'Product Name (SKU123)'.
=TEXTBETWEEN(A1, "(", ")")My dates are not recognized by Excel. They are just text strings.
=DATEVALUE(SUBSTITUTE(A1, ".", "/"))I need to change all instances of 'OldCompany' to 'NewCompany' in a column.
=SUBSTITUTE(A1, "OldCompany", "NewCompany")I want to create a simple in-cell bar chart by repeating the pipe symbol '|'.
=REPT("|", B1)I want to count how many commas are in a cell.
=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))I need a random 6-character code for user IDs.
=TEXTJOIN("",,CHAR(RANDARRAY(6,,65,90,TRUE)))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