Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]() "go_chrisg" wrote in message ... hmmmmm it seem i still am hving problems....heres the corrections to it =LEFT(A37,FIND(" ",A37)-1)+((MID(A37,FIND(" ",A37)+1,LEN(A37)-FIND(" ",A37))/12)) .... which is exactly what I suggested, except the change of cell reference from A1 to A37 (which I couldn't have guessed from your original post). Anyway, I'm glad it's sorted. Ian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
format number in feet and inches | Excel Discussion (Misc queries) | |||
How can I show Feet and inches in a Excel cell? | Excel Discussion (Misc queries) | |||
Measurement, in feet and inches, in Excel | Excel Discussion (Misc queries) | |||
Converting inches to feet & inches. | Excel Worksheet Functions | |||
How can I format a cell to accept feet and inches and add them | Excel Worksheet Functions |