23
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

*The 1st dimension *
*The 2nd dimension *
=MID(A1,FIND(“x”,A1)+1,FIND(“~”,SUBSTITUTE(A1,”x”,”~”,2))-(FIND(“x”,A1)+1))
*The 3rd dimension *
Let’s consider the below example image.



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 *!! **
23