IF ( Right ( self ; 1 ) = "'" or Right ( self ; 2 ) = "ft"
; Round ( Self * 12 * 2.54 / 100 ; 2 ) & "M"
; self )
thanks for your time much appreciated, works a treat
You might also want to change your design so that the units are entered into a separate field controlled with a drop down list to get more uniform entry of the data to begin with.