Microsoft Excel - VBA Code to letters from numbers in a cell.

Asked By KLNP on 21-Nov-14 09:48 AM
    My work sheet contains values in two cells "A" and "B".  Cell "A" contains the values like "61G" or "100G"
    Cell "B" contains values like "1000"  I want to multiply 1000 by the value in cell "A" by eliminating the last character "G"

Harry Boughen replied to KLNP on 08-Dec-14 08:38 AM
You could try:   =B1*LEFT(A1,LEN(A1)-1)