Formatting Feet and Inches in one cell

Hi all,   I am working with a spreadsheet of archived baseball team rosters (each year's roster is contained as one sheet in the larger workbook).  These were previously on paper, but are now being...