I have had the same problem and used the Replace function to deal with it.
Dim strUse As String
strUse = Replace(me.Text1, Chr(34), " inches")
Whenever me.Text1 contains something like: 13' 11"
The value is changed to: 13' 11 inches
You can then use strUse as you wish with worrying about an...