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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Cell data entering slow! 0
Display weeks from a Milestone 0
Remove Identical words 0
pieces picked per hour 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
How to center adjust text above and image in a two column document. 1
How can the font and size of (all) citation numbers be altered? 1

Top