Adding Cells with a letter in one of them

  • Thread starter Thread starter Jim
  • Start date Start date
J

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
 
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
 
Back
Top