Extract Text Before First Comma or Space in Excel Office 365!!
Tags: excelpreface, extracttextbeforethe, excelbasics, exceltutorials
Published: 2021-01-25 10:35:45

---
title: Extract Text Before First Comma or Space in Excel Office 365!!
published: true
date: 2021-01-24 16:17:39 UTC
tags: ExcelPreface,Extracttextbeforethe,ExcelBasics,ExcelTutorials
canonical_url: https://geekexcel.com/extract-text-before-first-comma-or-space-in-excel-office-365/
---

In this post, we will explain the way to **extract text before the first comma or space in Excel Office 365** with formula syntax, explanation, and clear-cut examples. You just follow the instructions that are given below and get the text string easily in your worksheet. Let’s see them below.
## Formula Syntax and Explanation:

- Use the below-given formulas to get the text string before comma or space.

**To get the text before the first space:**

**=[LEFT](https://geekexcel.com/how-to-use-left-function-in-microsoft-excel-365/)(A1,[FIND](https://geekexcel.com/how-to-use-find-function-in-microsoft-excel-365/)(” “,A1,1)-1)**

**To extract the text before the first space:**

**=[LEFT](https://geekexcel.com/how-to-use-left-function-in-microsoft-excel-365/)(A1,[FIND](https://geekexcel.com/how-to-use-find-function-in-microsoft-excel-365/)(“,”,A1,1)-1)**

- **[LEFT Function](https://geekexcel.com/how-to-use-left-function-in-microsoft-excel-365/) –** It extracts the first character (starting from the left side) or characters from the given string based on the number you specified.
- **[FIND Function](https://geekexcel.com/how-to-use-find-function-in-microsoft-excel-365/) –** This function is used to find out the one text string inside the other.

## Practical Examples:

Let’s see how the above-given formula works for your reference.

### Example 1: Get Text Before Space

- For instance, you can see **four text strings** in **cell**   **A1** with space between them.

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

- Then, you have to apply the formula in **cell C1** and **click** the **Enter** key.

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

- After clicking the Enter button, you will see extracted text string in **Cell C1** as shown in the below image.

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

### Example 2: Get Text Before Comma

- In the below screenshot, you can see the example words in **Cell A1.**

![Input Text Strings](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/EXCEL_jygkOyOhgA.png)<figcaption id="caption-attachment-21389">Input Text Strings</figcaption>

- Now, you need to **apply** the **formula** in **Cell C1** and press **Enter** key.

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

- Finally, you will get the output text before the comma in the selected cell as shown in the below image.

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

## Conclusion:

In this useful post, we have explained the way to **extract text before the first comma or space in Excel Office 365** with formula syntax, explanation, and clear-cut examples. Kindly, leave your **queries/suggestions** in the below comment section. To learn more, check out our website **[Geek Excel](https://geekexcel.com/)!! **