Assuming you don't have mixed feet and inches within the same cell, you
could use the following formula to 'read' the text entry of feet as a
number and sum them together using an array formula:

=SUM(VALUE(LEFT(A1:A100,1)))

confirmed with Control+Shift+Enter, not just Enter.

the values of 1', 3' and 5' will return 9

If your cells contain mixed feet and inches, you can convert to decimal
feet (e.g. 1' 3" = 1.25 feet) and sum the results:
(note: this assumes your data is entered with a space between the ' and
the next character, e.g. 1'_3")

=LEFT(A1,FIND("'",A1)-1)+(MID(A1,FIND(" ",A1)+1,LEN(A1)-FIND("
",A1)-1)/12)

HTH


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=390229