Excel
=EXCEL(...)Excel REGEXEXTRACT: Extract Patterns and Substrings
Extract specific text patterns, numbers, email addresses, and codes in Excel using the native REGEXEXTRACT function.
Explore ↗
#text-functions
5 formula guides
Excel
=FILTER(...)Excel TEXTJOIN with Conditions: Merge Filtered Strings
Combine text from multiple cells conditionally in Excel using TEXTJOIN, IF, and dynamic array FILTER formulas.
Explore ↗
Excel
=EXCEL(...)Excel TRANSLATE Function: Translate Text in Cells
Use Excel TRANSLATE and DETECTLANGUAGE to process text columns, check limits, and handle failures safely.
Explore ↗
Excel
=EXCEL(...)Excel REGEX Functions: REGEXTEST, REGEXEXTRACT, REGEXREPLACE
Learn REGEX functions in Excel. Use REGEXTEST, REGEXEXTRACT, and REGEXREPLACE to match text patterns without VBA.
Explore ↗
Google Sheets
=SPLIT,(...)SPLIT, TEXT, and Text Functions in Google Sheets
Learn SPLIT and text functions in Google Sheets. Split text, extract characters, and format data with examples.
Explore ↗