Google Sheets Formula Directory
Explore our comprehensive library of Google Sheets formulas with examples, use cases, and our interactive formula generator.
Showing 5 formulas in Text
LEFT
=LEFT("Hello", 2)Extracts a specified number of characters from the start of a text string in Google Sheets.
View formula detailsMID
=MID("Hello", 2, 3)Extracts a substring from the middle of a text string in Google Sheets, based on position and length.
View formula detailsRIGHT
=RIGHT("Hello", 2)Extracts a specified number of characters from the end of a text string in Google Sheets.
View formula detailsSUBSTITUTE
=SUBSTITUTE("Hello", "l", "x")Replaces specific text within a string with new text in Google Sheets, useful for text editing.
View formula detailsTRIM
=TRIM(" Hello World ")Removes extra spaces from text in Google Sheets, leaving single spaces between words.
View formula detailsFormula Generator
Create custom formulas with our AI-powered tool
Can't find the formula you need?
Use our AI-powered Formula Generator to create custom Google Sheets 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
Transform Your Spreadsheet Experience
Join thousands of users revolutionizing their data workflows. Get access to premium tools and expert knowledge.