Need a formula to isolate a number from a text string

[chicolocal]

I am having trouble writing a trim formula that looks at a particular cell and isolates the numbers/text preceding the inches (") measurement.

For example:

7" Extended Performance Blade
Construction 12" Combo Pack
Series 20 12" 60 Tooth Fine Finish Saw Blade
6-1/2" x 1/8" Concrete/Masonry Saw Blade

becomes

7"
12"
12"
6-1/2" 1/8"

any suggestions?

Thanks!

[Andrew-R]

This is a nightmare using formula, it would be must easier with a user defined function...

Please Login or Register  to view this content.

Then, with your data in A1:

=GetInches(A1)

[chicolocal]

BRILLIANT! Works perfect. Thank you.