Hi All,
This is my first post on Mr. Excel and I have found this site to be extremely helpful. Im struggling to parse out information from a string of text.
Im struggling to be able to extract dimensional information from a description, below is a sample of descriptions and the expected output. Any help you can provide to write formulas for Dimensions 1, 2 & 3 would be excellent. Like I said this is my first post so if im missing key details please let me know.
This is my first post on Mr. Excel and I have found this site to be extremely helpful. Im struggling to parse out information from a string of text.
Im struggling to be able to extract dimensional information from a description, below is a sample of descriptions and the expected output. Any help you can provide to write formulas for Dimensions 1, 2 & 3 would be excellent. Like I said this is my first post so if im missing key details please let me know.
| Description | Dimension 1 | Dimension 2 | Dimension 3 |
| LAGOON 18-0 x 29-10 x 34-6 RIGHT | 18-0 | 29-10 | 34-6 |
| RECTANGLE 2FT RAD 16-0 x 38-0 | 16-0 | 38-0 | |
| KIDNEY 18-0 x 19-11 x 33-5 Left | 18-0 | 19-11 | 33-5 |
| TRUE-L 90DEG 18-0 x 42-0 x 42-0 RIGHT | 18-0 | 42-0 | 42-0 |
| MOUNTAIN POND 17-0 x 23-4 x 45-0 LEFT | 17-0 | 23-4 | 45-0 |
| OMNI 15-0 x 22-5 x 34-6 RIGHT | 15-0 | 22-5 | 34-6 |
| RECTANGLE 6IN RAD 18-0 x 36-0 | 18-0 | 36-0 | |
| KIDNEY 18-0 x 20-0 x 33-8 LEFT | 18-0 | 20-0 | 33-8 |
| TECH-RIO 14-3 x 16-10 x 28-6 Left | 14-3 | 16-10 | 28-6 |
| GEMINI 18-0 x 21-5 x 36-1 Left | 18-0 | 21-5 | 36-1 |
| RECTANGLE 2FT RAD 18-0 x 36-0 | 18-0 | 36-0 | |
| PATRICIAN 6IN RAD 16-0 x 40-1 | 16-0 | 40-1 |
