How to convert 6'-3 3/8" to usable numbers
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
|