I'm trying to convert 2'-8" to 32 in Excel. Any ideas? Thanks a TON to anyone that can help. -m
M Mike Jul 13, 2004 #1 I'm trying to convert 2'-8" to 32 in Excel. Any ideas? Thanks a TON to anyone that can help. -m
T Tom Ogilvy Jul 13, 2004 #2 I don't know how generalized the technique needs to be, but for the specific construct you show: Demo'd from the immediate window sStr = "2'-8""" ? sStr 2'-8" varr = split(sStr,"-") ? val(varr(0))*12 + val(varr(1)) 32 Assumes xl2000 or later
I don't know how generalized the technique needs to be, but for the specific construct you show: Demo'd from the immediate window sStr = "2'-8""" ? sStr 2'-8" varr = split(sStr,"-") ? val(varr(0))*12 + val(varr(1)) 32 Assumes xl2000 or later
