remove muliplication function and see the original figure

  • Thread starter Thread starter hiran
  • Start date Start date
H

hiran

in a worksheet there are number of cells contains result of multiplication
between two numbers. I want to remove all multiplication and want to see only
the orginal number before multiplication. ie the first number of two numbers.
 
Think you could play with these steps in a spare copy

Presuming that you have in A2 down,
these sort of "in-cell" calcs (multiplication of 2 nums)

=200*3
=2*300
=0.2*0.3
etc

Select the range, do an Edit > Replace
Find: = (type an equal sign)
Replace with: (Leave it blank)
Click "Replace All"

Then place in B2: =LEFT(A2,SEARCH("~*",A2)-1)+0
Copy down, and you would get the desired results:

200
2
0.2

Success? Click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
 
Back
Top