Split dimensions into two parts

To split dimensions like "100x50" into two separate parts, you can use formulas based on several functions: LEFT, MID, RIGHT, FIND, LEN, and SUBSTITUTE. Note: you can also use Flash Fill in Excel 2013 and above, and the "Text to columns" feature in earlier versions of Excel. Both approaches are simpler than the formulas described below. However, for a formula-based solution, read on.

April 14, 2025 · 1 min · 98 words · Alexander Adams

Table of Contents

Extracting individual dimensions from a text representation can be done with formulas that combine several text functions.

That will “normalize” the dimensions and simplify the formulas that do the actual extraction.

The result is a dimension with just the “x” separating the two parts.

Using the SUBSTITUTE function to strip units and spaces

Now we can two relatively straightforward formulas to extract each part.

For more detail, see the related function links on this page.

For example, =LEFT(“apple”,3) returns “app”.

Using the SUBSTITUTE function to strip units and spaces

For example, =RIGHT(“apple”,3) returns “ple”.

When the text is not found, FIND returns a #VALUE error.

How to create a complex formula step by step

Using the SUBSTITUTE function to strip units and spaces

Using the SUBSTITUTE function to strip units and spaces

Using the SUBSTITUTE function to strip units and spaces

Using the LEFT function to grab the dimension on the left

Using the RIGHT function to grab the dimension on the right

Excel formula: Get first name from name

Excel formula: Get first name from name with comma

Excel formula: Split dimensions into three parts

Excel formula: Split text string at specific character

Excel SUBSTITUTE function

Excel LEFT function

Excel RIGHT function

Excel FIND function

Using the SUBSTITUTE function to strip units and spaces

Using the LEFT function to grab the dimension on the left

Using the RIGHT function to grab the dimension on the right