Get text between comma in Google Sheets

A2 = data cell

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?
Get text between commas in Google Sheets

GET TEXT BETWEEN COMMAS — GOOGLE SHEETS FORMULA AND EXAMPLE

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

Other useful extract formulas in Excel and Google Sheets explainedOthers FormulasDate and time functionsNumber based criteriaText-based criteriaExtract functions