How to Extract Text Between Commas in Excel Office 365?
Tags: excelpreface, extracttextbetweenco, excelbasics, exceltutorials
Published: 2021-01-25 10:35:23

---
title: How to Extract Text Between Commas in Excel Office 365?
published: true
date: 2021-01-23 17:20:36 UTC
tags: ExcelPreface,ExtractTextBetweenCo,ExcelBasics,ExcelTutorials
canonical_url: https://geekexcel.com/how-to-extract-text-between-commas-in-excel-office-365/
---

In this short article, we will see how to **Extract Text Between Commas in Excel Office 365**. To achieve this, we are going to use the **[SUBSTITUTE](https://geekexcel.com/how-to-use-substitute-function-in-microsoft-excel-2013/), [MID](https://geekexcel.com/how-to-use-mid-function-in-microsoft-excel-365/), [REPT](https://geekexcel.com/how-to-use-rept-function-in-microsoft-excel-2013/)** functions of Excel. Here, we have provided the syntax, explanation, and practical example for your quick understanding. Let’s see them below.
## Syntax and Explanation:

- You can use the below-mentioned formula to extract text between commas in Excel.

**=[SUBSTITUTE](https://geekexcel.com/how-to-use-substitute-function-in-microsoft-excel-2013/)([MID](https://geekexcel.com/how-to-use-mid-function-in-microsoft-excel-365/)(SUBSTITUTE(“,” & A1&[REPT](https://geekexcel.com/how-to-use-rept-function-in-microsoft-excel-2013/)(” “,6), “,” , REPT(“,”,255)),2\*255,255),”,”,””)**  

- **SUBSTITUTE function –** It can replace existing text with new text in a text string when you want to replace text based on its content, not position.
- **MID function –** This function will extract digits from the given number as well. It extracts the number (starting from the left side) or characters from the given string.
- **REPT function –** It repeats characters a given number of times.

## Practical Example:

- First, you need to [open the workbook](https://geekexcel.com/open-a-workbook-using-shortcut-in-excel-365/).
- Assuming that we have entered some example words in **Cell A1 and A2** that are separated by a comma.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/EXCEL_Krk6uBzK8N.png)<figcaption id="caption-attachment-21289">Example</figcaption>

- To get the text between commas, you need to **apply** the above-given **formula.**

![Apply the formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/EXCEL_6it9X0B1vf.png)<figcaption id="caption-attachment-21290">Apply the formula</figcaption>

- After applying the formula, you need to **press** the **Enter** key to get the result as shown in the below screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/EXCEL_D7MkDUwkgO.png)<figcaption id="caption-attachment-21291">Output</figcaption>

## A Short Summary:

In this short article, you can clearly understand the steps to **Extract Text Between Commas in Excel Office 365** using SUBSTITUTE, MID, REPT functions. You just follow the steps to extract the word or text between commas in your worksheet. Drop your **feedback** in the below comment section. Thanks for visiting **[Geek Excel!!](https://geekexcel.com/)** Keep Learning!!

### Read Ahead:

- [Use Find & Replace Tool to Replace Text in Excel Office 365](https://geekexcel.com/use-find-replace-tool-to-replace-text-in-excel-office-365/)
- [Excel Formulas to Lookup Multiple Criteria with INDEX and MATCH!!](https://geekexcel.com/excel-lookup-multiple-criteria-with-index-and-match/)
- [How to Print Multiple Copies in Excel Office 365!!](https://geekexcel.com/how-print-multiple-copies-in-excel/)
- [How to Enter a Time in Excel Worksheet?](https://geekexcel.com/enter-a-time-in-excel/)