Excel Guides

Breaking Up Variable-Length Part Numbers in Excel

When it comes to breaking up variable-length part numbers in Excel, there are a few different methods that you can use. Each has its own set of pros and cons, so it's important to choose the method that will work best for your particular needs. Here's a look at a few of the most popular methods:

Method 1: Use the Text to Columns Feature

One of the easiest ways to break up a variable-length part number in Excel is to use the "Text to Columns" feature. This feature can be found under the "Data" tab in the ribbon menu. To use it, simply select the cells containing the part numbers that you want to split up, then click on "Text to Columns."

In the "Text to Columns" dialog box, make sure that the "Delimited" option is selected, then click on "Next." In the next dialog box, check the box next to "Space," then click on "Finish." This will cause Excel to split up the part numbers into separate columns, based on where the spaces are located.

Method 2: Use a Formula

If you're comfortable working with formulas in Excel, you can use a simple formula to break up a variable-length part number. The formula that you'll need to use is as follows:

=LEFT(A1,FIND(" ",A1)-1) 

This formula will extract the first section of a part number (up until the first space). To get the second section of the part number (after the first space), you can use this modified version of the formula:

=RIGHT(A1,LEN(A1)-FIND(" ",A1)) 

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.