Google Sheets Formulas
How to Split Text by Multiple Delimiters in Google Sheets
Learn how to split text by multiple delimiters in Google Sheets using SUBSTITUTE, SPLIT, REGEX, ARRAYFORMULA, or Apps Script for automation.
Read article
Google Sheets Formulas
63 articles
Google Sheets Formulas
How to Remove Formula and Keep Value in Google Sheets
Learn how to remove formulas but keep values in Google Sheets using the Paste Values feature or the values-only option from the toolbar.
Read article
Google Sheets Formulas
How to Capitalize All Letters in Google Sheets (3 Simple Methods)
Learn how to capitalize all letters in Google Sheets using the UPPER function, ArrayFormula for bulk edits or third-party add-ons.
Read article