On Tue, 11 Mar 2008 06:58:02 -0700, 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!

Feet:

=--LEFT(A1,FIND("'",A1)-1)

Inches:

=--MID(A1,FIND("-",A1)+1,FIND("""",A1)-FIND("-",A1)-1)

--ron