Get text between colons in Google Sheets

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

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

How to get text between colons in Google Sheets?

GET TEXT BETWEEN COLONS — GOOGLE SHEETS FORMULA AND EXAMPLE

=ARRAYFORMULA(TRIM(REGEXREPLACE(A2, "_|:|\*", " ")))
- Get text between colons
=ARRAYFORMULA(TRIM(REGEXREPLACE(A2, "_|,|\*", " ")))
- Get text between commas
=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