|
| | | Forum Newbie
Group: Forum Members
Last Login: 8/5/2010 7:27:09 AM
Posts: 3, Visits: 4 |
| I need help with making excel read a formula. For example I have 4' 5" typed in one cell. i want excel to recognize that as "ft" "in". And this is important because i have an sumif scenerio that is suppose to subtract according to a scenerio. Is there a way for excel to recognize the entry as measurement? If so, how can i make it recognize it?
corporate hospitality packages |
| |
| | | Forum Newbie
Group: Forum Members
Last Login: 7/9/2010 6:54:21 AM
Posts: 3, Visits: 3 |
| I don't think you can have 4' 5" treated as a value, but you can convert it to a value using this formula (data in A1):
=VALUE(LEFT(A1,1))*12 + VALUE(MID(A1,4,LEN(A1)-4))
Buttons And Triangles In Cells |
| |
|
|