Thread
:
a cell contains both text and number
View Single Post
#
1
text and formulas
Posts: n/a
a cell contains both text and number
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"
Reply With Quote
a cell contains both text and number