Excel Formulas to Trim the Text into N Number of Words ~ Simple Tricks!!
Tags: excelformula, excelformulas
Published: 2021-06-25 06:57:00

---
title: Excel Formulas to Trim the Text into N Number of Words ~ Simple Tricks!!
published: true
date: 2021-06-19 08:49:49 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-trim-the-text-into-n-number-of-words/
---

Assume that you have a long text string, and you need to **trim the text string into N number of words** only. How could you solve this task in Excel? Today I introduce you to some formulas to solve this problem. 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)

[![Trim the text into n number of words](https://geekexcel.com/wp-content/uploads/2021/06/Trim-the-text-into-n-number-of-words.png)](https://geekexcel.com/excel-formulas-to-trim-the-text-into-n-number-of-words/trim-the-text-into-n-number-of-words/#main)<figcaption id="caption-attachment-47624">Trim the text into n number of words</figcaption>

## Generic Formula:

- If you want to split the text and numbers in Excel, you can use the below formula.

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

## Syntax Explanations:

- **LEFT** – It extracts the first character (starting from the left side) or characters from the given string based on the number you specified. Read more on the **[LEFT function](https://geekexcel.com/how-to-use-left-function-in-microsoft-excel-365/)**.
- **FIND** – In Excel, the **[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.
- **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/).
- **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.

## Practical Example:

Refer to the below example image.

- Here we will enter the input values in **Column B** and **Column C**.
- Now we are going to trim the text into a given number of words.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/06/Input-Ranges-43.png)<figcaption id="caption-attachment-47626">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-57.png)<figcaption id="caption-attachment-47625">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-45.png)<figcaption id="caption-attachment-47627">Result</figcaption>

## Closure:

In this chapter, we will discuss **how to trim the text into N number of words in Excel**. I hope that this article is useful. We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Share your worthwhile **feedback** in the below **comment** section.

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 Also:

- **[Excel Formulas to Split the Dimensions into Two Parts ~ Easily!!](https://geekexcel.com/excel-formulas-to-split-the-dimensions-into-two-parts-easily/)**
- **[How to Validate Only Numbers in Cell in Excel Office 365?](https://geekexcel.com/how-to-validate-only-numbers-in-cell-in-excel-office-365/)**
- **[Excel Formulas to Replace One Character with Another ~ Quickly!!](https://geekexcel.com/excel-formulas-to-replace-one-character-with-another/)**
- **[How to Search for a Value in All Tabs in Excel Office 365?](https://geekexcel.com/how-to-search-for-a-value-in-all-tabs-in-excel-office-365/)**