a cell contains both text and number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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"
 
Back
Top