This only works in Google sheets. The test string is a sheets formula that converts feet inches in this<6' 6"> into the total number of inches.