a cell contains both text and number

T

text and formulas

how do i make a calculation if a cell has text and a number. Example the cell
says "3 weeks" I want to calculate 3 weeks to read in the next column as "120
hours"
 
Top