Forum Discussion

Copper Contributor

Oct 10, 2019

Solved

Help with a formula to sort dimensions?

Hello, I am trying to determine which excel formula would be the best to create a spread sheet that will automatically input the dimensions for lumber into a given cell. The excerpt below shows t...

excel

Formulas and Functions

Twifoo
Oct 10, 2019
Hi J-Griff,
In the attached file, the formula for Thick in B2 is:
=LEFT($E2,
FIND("x",$E2)-1)
Moreover, the formula for Width in C2 is:
=MID($E2,
FIND("x",$E2)+1,
FIND("-",$E2)-FIND("x",$E2)-1)
Finally, the formula for Length in D2 is:
=MID($E2,
FIND("-",$E2)+1,
FIND(" ",$E2)-FIND("-",$E2)-1)
CharExtracts.xlsx9 KB

Twifoo

Silver Contributor

Oct 10, 2019

Hi J-Griff,

In the attached file, the formula for Thick in B2 is:

=LEFT($E2,
FIND("x",$E2)-1)

Moreover, the formula for Width in C2 is:

=MID($E2,
FIND("x",$E2)+1,
FIND("-",$E2)-FIND("x",$E2)-1)

Finally, the formula for Length in D2 is:

=MID($E2,
FIND("-",$E2)+1,
FIND(" ",$E2)-FIND("-",$E2)-1)

CharExtracts.xlsx9 KB

J-Griff
Copper Contributor
Oct 10, 2019
Twifoo, Thank you so much for your help! I was able to get the first line to work with all three formulas you provided. And as you can see in the attached excel document, the first two columns, thick & width, work perfectly, but I can't figure out why the subsequent lines in the length column are not computing correctly?

Any advice?

Thanks,

John
~Coversheet & Deliveries TEST 2.xls156 KB
- Twifoo
  Silver Contributor
  Oct 10, 2019
  J-Griff
  Except for F7 and F43, I noticed that the entries under Column F includes a space character (" ") after the "X" character. The pattern of the entries under Column F must be uniform!
  - J-Griff
    Copper Contributor
    Oct 10, 2019
    Twifoo is there a way to add the second condition to the formula in order to capture the same data? Perhaps if we incorporated an IF formula? I am just spit balling here, I have no clue how that would look.