Get text between comma in Google Sheets

  1. =ARRAYFORMULA(TRIM(REGEXREPLACE(A2, "_|,|\*", " "))) // Get text between commas

  2. =ARRAYFORMULA(TRIM(REGEXREPLACE(A2, "_|:|\*", " "))) // Get text between colons

  3. =ARRAYFORMULA(TRIM(REGEXREPLACE(A2, "_|;|\*", " "))) // Get text between semicolons

A2 = data cell

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