Excel Formulas to Extract the Word that Begins with Specific Character!!
Tags: excelformula, excelformulas
Published: 2021-06-19 03:09:41

---
title: Excel Formulas to Extract the Word that Begins with Specific Character!!
published: true
date: 2021-06-10 11:04:35 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-extract-the-word-that-begins-with-specific-character/
---

Suppose, you may need to extract the **word which begins with a specific character** “=” for each cell as the below screenshot shown. How could you solve this task quickly and easily in Excel? Today I introduce you to some formulas to solve this problem in Excel. Let’s see them below!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

![Extract a word that begins with specific character](https://geekexcel.com/wp-content/uploads/2021/06/Extract-a-word-that-begins-with-specific-character.png)<figcaption id="caption-attachment-46290">Extract a word that begins with a specific character</figcaption>

## Generic Formula:

- Use the below formula to extract the word that begins with a certain character in Excel.

**=[TRIM](https://geekexcel.com/use-trim-function-in-microsoft-excel-2013-simple-methods/)([LEFT](https://geekexcel.com/how-to-use-left-function-in-microsoft-excel-365/)([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/)(text,[FIND](https://geekexcel.com/how-to-use-find-function-in-microsoft-excel-365/)(“=”,text),[LEN](https://geekexcel.com/how-to-use-len-function-in-microsoft-excel-365/)(text)),” “,[REPT](https://geekexcel.com/how-to-use-rept-function-in-microsoft-excel-2013/)(” “,100)),100))**

## Syntax Explanations:

- **TRIM**  – It helps to remove the extra spaces from the text and there is no space at the start or end of the text string. Read more on the [**TRIM function**](https://geekexcel.com/use-trim-function-in-microsoft-excel-2013-simple-methods/).
- **LEFT** -In Excel, the **[LEFT function](https://geekexcel.com/how-to-use-left-function-in-microsoft-excel-365/)** will help to extract the first character (starting from the left side) or characters from the given string based on the number you specified.
- **MID** – This function helps to extract the number (starting from the left side) or characters from the given string. Read more on the **[MID function](https://geekexcel.com/how-to-use-mid-function-in-microsoft-excel-365/)**.
- **SUBSTITUTE**  – This function helps to replace existing text with new text in a text string when you want to replace text based on its content, not position. Read more on the [**SUBSTITUTE function**](https://geekexcel.com/how-to-use-substitute-function-in-microsoft-excel-2013/).
- **REPT**  – In Excel, the **[REPT function](https://geekexcel.com/how-to-use-rept-function-in-microsoft-excel-2013/)** is used to repeat characters a given number of times.
- **LEN** – This function helps to find the length of the text string.  Read more on the [**LEN function**](https://geekexcel.com/how-to-use-len-function-in-microsoft-excel-365/).
- **FIND**  – The Excel, **[FIND function](https://geekexcel.com/how-to-use-find-function-in-microsoft-excel-365/)** is used to find out the one text string inside the other.
- **Text** – It represents the input value.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Example:

Refer to the below example image.

- First, we will enter the input text strings in **Column B**.
- Now we need to extract the text that starts with the **“=”** symbol.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/06/Input-Ranges-21.png)<figcaption id="caption-attachment-46285">Input Ranges</figcaption>

- Select any cell and type the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/06/Enter-the-formula-30.png)<figcaption id="caption-attachment-46283">Enter the formula</figcaption>

- Finally, press the ** ENTER** key, you can get the result as shown below.

![Result](https://geekexcel.com/wp-content/uploads/2021/06/Result-26.png)<figcaption id="caption-attachment-46286">Result</figcaption>

## Wind-Up:

In this blog post, we have described the formulas to **extract the word that begins with the specific character in Excel**. Hope you like it. Mention your **queries** in the **comment** box below.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Ahead:

- **[Excel Formulas to Extract Nth Word From a Text String ~ Simple Tips!!](https://geekexcel.com/excel-formulas-to-extract-nth-word-from-a-text-string-simple-tips/)**
- **[Excel Formulas to Count specific word in a range ~ Easy Tutorial!!](https://geekexcel.com/excel-formulas-to-count-specific-words-in-a-range/)**
- **[Formulas for Extracting Substring Between Two Texts in Excel 365!!](https://geekexcel.com/formulas-for-extracting-substring-between-two-texts-in-excel-365/)**
- **[Excel Formulas to Extract the Month Number from Name!!](https://geekexcel.com/excel-formulas-to-extract-month-number-from-name/)**