| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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" |
|
#2
|
|||
|
|||
|
=LEFT(A1,1)*1*40&" hours"
Vaya con Dios, Chuck, CABGx3 "text and formulas" <text and wrote in message ... 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" |
|
#3
|
|||
|
|||
|
Redundant 1, twice<bg
=LEFT(A1)*40&" Hours" -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "CLR" wrote in message ... =LEFT(A1,1)*1*40&" hours" Vaya con Dios, Chuck, CABGx3 "text and formulas" <text and wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 16 digit number wont keep alteration unless format cell to text | Excel Discussion (Misc queries) | |||
| Defining a number in a cell by text then subtracting it by the tex | Excel Worksheet Functions | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
| returning a text cell based on a number cell | Excel Worksheet Functions | |||
Linear Mode
