Excel Formulas to Split the Dimensions into Three Parts ~ Simple Tips!!

Excel allows a user to split dimensions into several parts using several functions: SUBSTITUTE, RIGHT, LEFT, FIND,and LEN. This step-by-step tutorial will assist you to split the dimensions into three 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:

Use the below formula to split the dimensions into three parts in Excel.

*The 1st dimension *

=LEFT(A1,FIND(“x”,A1)-1)

*The 2nd dimension *

=MID(A1,FIND(“x”,A1)+1,FIND(“~”,SUBSTITUTE(A1,”x”,”~”,2))-(FIND(“x”,A1)+1))

*The 3rd dimension *

=RIGHT(A1,LEN(A1)-FIND(“~”,SUBSTITUTE(A1,”x”,”~”,2)))

Syntax Explanations:

LEFT – In Excel, the LEFT function will help to extract the first character (starting from the left side) or characters from the given string based on the number you specified.
FIND – The Excel FIND function is used to find out the one text string inside the other.
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.
RIGHT – The RIGHT Function in Excel is used to extract the texts with the given number of characters from the right side.
LEN – In Excel, the LEN function returns the length of a given text string as the number of characters.
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.
Plus operator (+) – This symbol is used to add the values.
Minus Operator (-) – This symbol will help to subtract any two 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 dimensions into three parts.

Select any cell and type the above-given formula.

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

Wind-Up:

So yeah guys this is how you can split the dimensions into three parts 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!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **