[SOLVED] a cell contains both text and number

[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"

[CLR]

=LEFT(A1,1)*1*40&" hours"

Vaya con Dios,
Chuck, CABGx3



"text and formulas" <text and [email protected]> wrote in
message news:[email protected]...
> 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"

[RagDyer]

Redundant 1, twice<bg>

=LEFT(A1)*40&" Hours"
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"CLR" <[email protected]> wrote in message
news:[email protected]...
> =LEFT(A1,1)*1*40&" hours"
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
> "text and formulas" <text and [email protected]> wrote in
> message news:[email protected]...
> > 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"
>
>