Excel Formulas to Split the Dimensions into Two Parts ~ Easily!!

In the previous post, we have learned the formulas to split the dimensions into three parts. Similarly, here we are going to split the dimensions into two parts 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

General Formula:

If you want to split the dimensions into two parts in Excel.

=SUBSTITUTE(SUBSTITUTE(A1,”ft”,””),” “,””)

Syntax Explanations:

SUBSTITUTE – This function can 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.
A1 – 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:

Let’s consider the below example image.

First, we will enter the input text strings in Column B.
Here we need to enter the split the text into two parts.

Select any cell and type the above-given formula.

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

Verdict:

In this chapter, we have described the formulas to split the dimensions into two parts in Excel. Leave a comment or reply below to let me know what you think!

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **