Excel Formula Directory
Explore our comprehensive library of spreadsheet formulas with examples, use cases, and our interactive formula generator.
Showing 6 formulas in Text
CONCATENATE (deprecated, use CONCAT)
=CONCATENATE(A1, " ", B1)Combining multiple text strings into one (deprecated, use CONCAT)
View formula detailsLEFT
=LEFT("Hello", 2)Extracting characters from the start of a text string
View formula detailsMID
=MID("Hello", 2, 3)Extracting a substring from the middle of text
View formula detailsRIGHT
=RIGHT("Hello", 2)Extracting characters from the end of a text string
View formula detailsSUBSTITUTE
=SUBSTITUTE("Hello World", "World", "Excel")Replacing specific text with new text in a string
View formula detailsTRIM
=TRIM(" Hello World ")Removing excess spaces from text for clean data
View formula detailsCan't find the formula you need?
Use our AI-powered Formula Generator to create custom formulas for any task. Simply describe what you want to calculate in plain language.
Popular formula requests:
- Calculate the sum of values when multiple conditions are met
- Extract specific text between two characters
- Look up values across multiple sheets with fallback options
- Calculate business days between two dates excluding holidays
Unlock the Full Power of Sheet Alchemy
Get access to all our formula generators, script generators, and conversion tools with a free Sheet Alchemy account.