How to Remove Unwanted Text From Multiple Columns In Google Spreadsheet

How to Remove Unwanted Text From Multiple Columns In Google Spreadsheet

Removing unwanted text from multiple datasets is a tedious task, but Google Spreadsheet made it is easy. There are inbuilt REGEX functions in Google Spreadsheet that makes it super simple to work with regular expression. Let’s learn how to remove unwanted text from multiple columns in Google Spreadsheet.

Question: Let’s assume you have a dataset of 6 columns (A:F) and there are some text values in it (See below image). You need to extract the only text before the special characters.

Solution: You can use ARRAYFORMULA and REGEXEXTRACT together to remove unwanted text from a range of columns.

The beauty of this formula is, you don’t have to apply multiple formulas in each row. Just One formula will work.

Formula:

=ARRAYFORMULA(REGEXEXTRACT(A3:F8,"[A-Za-z ]+"))
How to Extract Unwanted Text From Multiple Columns In Google Spreadsheet

 Read More:

How to send email notifications on Google Spreadsheets if any cell value changes

COMMENTS