Extracting Values from Text

T

Tony D

Thanks very much in advance for any solutions that can be offered.

What formula would I use to provide the following result:

A
B C
1 123456-text 3" x 6 7/8" etc etc 3 6.875
2 654321-test 104 1/2" x 80 3/4" etc etc 104.5 80.75

The length is always shown in inches (indicated as such the the single
quotation symbol). The length could be a whole number of fractional.

The spacing and position of the text above is exact (but length of
characters may vary).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top