|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 13th, 2005, 08:37 PM
|
|||
|
|||
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
June 13th, 2005, 09:36 PM
|
|||
|
|||
|
=LEFT(A1,1)*1*40&" hours"
Vaya con Dios, Chuck, CABGx3 "text and formulas" text and wrote in message news  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
June 14th, 2005, 12:10 AM
|
|||
|
|||
|
Redundant 1, twicebg
=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 news 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"
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Combo Box (1st) Populating Text Box (2nd) Field | AccessRookie | Using Forms | 1 | April 6th, 2005 11:37 PM |
| Combo Box & Text Box | AccessRookie | Using Forms | 3 | April 6th, 2005 11:33 PM |
| Change font of part of text | John | Powerpoint | 7 | March 15th, 2005 10:10 AM |
| Help with design | Ronnie | Database Design | 6 | March 12th, 2005 02:53 PM |
| GET.CELL | Biff | Worksheet Functions | 2 | November 24th, 2004 07:16 PM |
Linear Mode
