Extract Numbers From Mixed Text String with Function in Excel 365!!
Tags: kutoolsexceltutorial, stepstoextractnumber, kutools
Published: 2020-10-08 08:02:03

---
title: Extract Numbers From Mixed Text String with Function in Excel 365!!
published: true
date: 2020-10-06 08:47:34 UTC
tags: KutoolsExcelTutorial,StepstoExtractNumber,Kutools
canonical_url: https://geekexcel.com/extract-numbers-from-mixed-text-string-with-function-in-excel-365/
---

In this tutorial, we will guide you to learn the steps to **Extract Numbers From Mixed Text String with Function in Excel Office 365** using **Kutools.** 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)

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## **Steps to Extract Numbers From Mixed Text String with Function:**

To extract numbers from mixed text string with function, do as below instructions.

- Let’s consider the below example to extract numbers from the mixed text string.

![Sample data](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Sample-data.png)<figcaption id="caption-attachment-15237">Sample data</figcaption>

- You need to **select a blank** cell to display the result.
- Then, on the **Kutools Tab, select** the **Kutools Functions** option, **choose** the **Text** option from the drop-down list, **select** the **EXTRACTNUMBERS** option.

![Select EXTRACTNUMBERS option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-EXTRACTNUMBERS-option.png)<figcaption id="caption-attachment-15238">Select EXTRACTNUMBERS option</figcaption>

- It will open the **Function Arguments dialog box.**
- **Txt box –** You need to specify the cell from which you want to extract numbers.
- **N box – ** You need to keep this box empty or give **TRUE/FALSE** Value as you need.

![Function Arguments dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Function-Arguments-dialog-box.png)<figcaption id="caption-attachment-15239">Function Arguments dialog box</figcaption>

### Note:

- N box – If you want to return numbers which are formatted and stored as text, then enter FALSE or leave it as an empty box.
- If you want to function returns numerical numbers, then you need to enter **TRUE** in the **N box**.

- Then, **click** the **OK** button to get the result in the selected cell.
- You need to select the first cell and drag it down to fill the remaining cells to get the output as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Result-4.png)<figcaption id="caption-attachment-15240">Result</figcaption>

## **Verdict:**

In this tutorial, you can clearly learn the steps to **Extract Numbers From Mixed Text String with Function in Excel Office 365** using **Kutools. ** Share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Keep Reading:

- [Find and Fill Missing Numbers in a Sequence in Excel](https://geekexcel.com/find-and-fill-missing-numbers-in-sequence-in-excel-office-365/)
- [Calculate Age By Date of Birth in Excel](https://geekexcel.com/how-to-calculate-age-by-date-of-birth-in-excel-office-365/)