Get text between comma in Google Sheets

=ARRAYFORMULA(TRIM(REGEXREPLACE(A2, "_|,|\*", " "))) // Get text between commas
=ARRAYFORMULA(TRIM(REGEXREPLACE(A2, "_|:|\*", " "))) // Get text between colons
=ARRAYFORMULA(TRIM(REGEXREPLACE(A2, "_|;|\*", " "))) // Get text between semicolons

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

Get text between commas in Google Sheets

How to get text between commas in Google Sheets?

=ARRAYFORMULA(TRIM(REGEXREPLACE(A2, "_|,|\*", " ")))
- Get text between commas
=ARRAYFORMULA(TRIM(REGEXREPLACE(A2, "_|:|\*", " ")))
- Get text between colons
=ARRAYFORMULA(TRIM(REGEXREPLACE(A2, "_|;|\*", " ")))
- Get text between semicolons

💡 In Excel "Find and Replace" will do the same job

Other useful extract formulas in Excel and Google Sheets explained

Others Formulas

Date and time functions

Number based criteria

Text-based criteria

Extract functions

Google Sites

Report abuse