Excel Formulas to Split the Numbers from Units of Measure ~ Easily!!
Tags: excelformula, excelformulas
Published: 2021-06-23 07:28:45

---
title: Excel Formulas to Split the Numbers from Units of Measure ~ Easily!!
published: true
date: 2021-06-17 05:07:35 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-split-the-numbers-from-units-of-measure/
---

Sometimes you encounter data that mixes units directly with numbers. Unfortunately, numbers in this format are considered to be text inside of Excel,  and you won’t be able to perform any math operations on such values. So here we will show the formulas to **split the number from a unit of measure in Excel**. Let’s step into this article!! 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)

[![Split number from a unit of measure](https://geekexcel.com/wp-content/uploads/2021/06/Split-number-from-a-unit-of-measure.png)](https://geekexcel.com/excel-formulas-to-split-the-numbers-from-units-of-measure/split-number-from-a-unit-of-measure/#main)<figcaption id="caption-attachment-46558">Split number from a unit of measure</figcaption>

## General Formula:

- Use the below formula to split the number from a unit of measure in Excel.

**=[MAX](https://geekexcel.com/how-to-use-excel-max-function-in-office-365-with-examples/)([ISNUMBER](https://geekexcel.com/how-to-use-isnumber-function-in-microsoft-excel-365/)([VALUE](https://geekexcel.com/how-to-use-value-function-in-microsoft-excel-2013/)([MID](https://geekexcel.com/how-to-use-mid-function-in-microsoft-excel-365/)(A1,{1,2,3,4,5,6,7,8,9},1)))\*{1,2,3,4,5,6,7,8,9})+1 **

## Syntax Explanations:

- **MAX** – In Excel, the [**MAX**  **function**](https://geekexcel.com/how-to-use-excel-max-function-in-office-365-with-examples/) will return the largest numeric value from the range of input values.
- **ISNUMBER** – The Excel [**ISNUMBER**  **function**](https://geekexcel.com/how-to-use-isnumber-function-in-microsoft-excel-365/) is used to return TRUE when a cell contains a number, and FALSE if there will not be a number.
- **VALUE** – The [**VALUE**  **Function**](https://geekexcel.com/how-to-use-value-function-in-microsoft-excel-2013/) in Excel is used to convert text into a numeric value.
- **MID** – It is used 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/)**.
- **A1** – It represents the input value.
- **Plus operator (+)** – This symbol is used to add the values.
- **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:

Let’s consider the below example image.

- Here, we will enter the input text strings in **Column B**.
- Now we are going to split the number into units of measure.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/06/Input-Ranges-40.png)<figcaption id="caption-attachment-46560">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-54.png)<figcaption id="caption-attachment-46559">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/Result1-8.png)<figcaption id="caption-attachment-46561">Result</figcaption>

## Wind-Up:

So yeah guys this is how you can **split a unit of measure in Excel**. Hope you like this article. Let me know if you have any **doubts** regarding this article or any other article on this site.

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 Replace One Character with Another ~ Quickly!!](https://geekexcel.com/excel-formulas-to-replace-one-character-with-another/)**
- **[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 Remove the Line Breaks Between Two Text Strings!!](https://geekexcel.com/excel-formulas-to-remove-the-line-breaks-between-two-text-strings/)**
- **[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/)**