Thank you for the fast and expert feedback; we'll give it a shot!
--
Marv Lusk


"BoniM" wrote:

If 6"-3 3/8" is in cell A2

=VALUE(LEFT(A2,FIND("'",A2)-1))

will give the number of feet

=MID(A2,FIND("-",A2)+1,FIND(" ",A2)-FIND("-",A2)-1)+MID(A2,FIND("
",A2)+1,FIND("/",A2)-FIND("
",A2)-1)/MID(A2,FIND("/",A2)+1,LEN(A2)-FIND("/",A2)-1)

will give the number of inches converted to decimal format.


"MarvInBoise" wrote:

I have a large spredsheet of data that comes in like 6'-3 3/8" that I need to
split out so I have the 6 (feet) in one column and the fractional inches (3
3/8) converted in the next column to 3.375, etc. Below is some sample data:

4'-1 3/8" to 4 | 1.375
9'-2 1/2" to 9 | 2.500
7'-3 1/8" to 7 | 3.125

Any help is greatly appreciated as these are weekly data conversion needs.

Thanks!
--
Marv Lusk