Adding Cells with a letter in one of them

[Jim]

I want to muliply 2 cells together, but one of the cells to have a letter in
it.
Cell A1 is 40p and Cell A2 is 4. Without the p in A1 a value is returned in
A3 of 160.
With the p in A1 a #Value is returned in A3.
Is there a way of getting this calculation to return the correct value of
the numbers in A1 and A2
with the p in A1.
Many thanks
Jim

 

[muddan madhu]

try this

=LEFT(A1,2)*A2

 

[Jim]

That does the trick!!!
Many thanks
Jim


try this

=LEFT(A1,2)*A2

 

[David Biddulph]

Or, if you're not sure how many digits before the letter, try
=LEFT(A1,LEN(A1)-1)*A2
--
David Biddulph

try this

=LEFT(A1,2)*A2