Google Sheets Formulas
How to Extract Numbers from a String in Google Sheets
Learn how to extract numbers from a string in Google Sheets using REGEXEXTRACT, ARRAYFORMULA, SPLIT function, and Power Tools add-on.
Read article
Google Sheets Formulas
63 articles
Google Sheets Formulas
How to Use VLOOKUP to Find Duplicates in Google Sheets
Learn how to use VLOOKUP in Google Sheets to find duplicates with ISNA, IFERROR, ARRAYFORMULA, helper columns, and the Statology method.
Read article
Google Sheets Formulas
Compare Two Columns & Find Missing Values in Google Sheets
Learn how to compare two columns in Google Sheets and find missing data using MATCH, ISNA, FILTER, VLOOKUP & conditional formatting methods.
Read article
Google Sheets Formulas
How to Split a Cell Horizontally In Google Sheets (5 Useful Methods)
Learn how to split a cell horizontally in Google Sheets using “Split Text to Columns,” SPLIT, REGEXEXTRACT, line breaks, and ARRAYFORMULA.
Read article
Google Sheets Formulas
How to Merge Cells in Google Sheets Without Losing Data
Learn how to merge cells in Google Sheets without losing data using CONCATENATE, JOIN, TEXTJOIN, ampersand (&), CHAR(10), and Apps Script.
Read article
Google Sheets Formulas
How to Find Duplicates in Two Columns in Google Sheets
Learn how to find duplicates in two columns in Google Sheets using Conditional Formatting, COUNTIF, and the Filter function for detection.
Read article
Google Sheets Formulas
How to Remove the First Character in Google Sheets (4 Formulas)
Learn how to remove the first character in Google Sheets using REPLACE, RIGHT+LEN, REGEXREPLACE, or the MID function effectively.
Read article
Google Sheets Formulas
How to Calculate Average in Google Sheets Ignoring 0 (Zero)
Learn how to calculate average in Google Sheets while ignoring 0 values using AVERAGEIF, FILTER, ARRAYFORMULA, and QUERY functions.
Read article
Google Sheets Formulas
How to Split Text to Rows in Google Sheets (2 Useful Formulas)
Learn how to split text to rows in Google Sheets using TRANSPOSE, SPLIT, and ARRAYFORMULA functions for efficient data transformation.
Read article
Google Sheets Formulas
How to Calculate Duration Between Two Times in Google Sheets
Learn how to calculate duration between two times in Google Sheets using subtraction, TEXT function, and methods to separate hours & minutes.
Read article
Google Sheets Formulas
How to Randomize a List in Google Sheets (4 Quick Tricks)
Learn how to randomize a list in Google Sheets using the Randomize Range tool, context menu, RAND, and RANDBETWEEN functions.
Read article
Google Sheets Formulas
How to Extract Text Between Two Characters in Google Sheets
Learn how to extract text between two characters in Google Sheets using formulas to pull text from parentheses, brackets, hyphens, or braces.
Read article