DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

Formulas to Extract Numbers From Mixed Text String with Function!!

In this short tutorial, we will guide you to learn the simple Formulas to Extract Numbers From Mixed Text String with Function in Excel Office 365 with its function explanations. Let’s get into this article!! Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Formula Syntax:

=EXTRACTNUMBERS(B2)

Example:

  • The below table shows how to extract the number from the mixed text in a function.
  • If you have the input ranges like Column A , you need to enter the given formula.
  • After applying the formula, it will display the output as shown below.

Result

Syntax Explanations:

  • EXTRACTNUMBERS – It is one of the Excel function which is available only in Kutools. The main purpose of this function is to separate the numbers from a mixed text.
  • Parenthesis () – This is used for grouping the elements.

Closure:

From this article, you can easily understand the function to separate the numbers from mixed text strings and numbers. You can also learn the formulas to extract numbers from the mixed text strings with function in Excel Office 365. If you have any doubts, feel free to share it with us. Thank you so much for Visiting Our Site!! Continue learning on Geek Excel!!

Read Also:

Top comments (0)