Multiply Function

  • Thread starter Thread starter Manos
  • Start date Start date
M

Manos

Dear Folks,

I have a small laptop and i am using excel for cxounting stock in the
warehouse i am working. For the fast use i am in one column eg.
A1 3*5
A2 2*9
A3 10*28

There is any way that i can have the result of this number in the column B

eg:
B1 15
B2 18
B3 280

The problem is that for quick use i don't type the equal symbol in the first
column, just the numbers.

Can anyone help me with that problem? Thanks in advance...

With regards Manos
 
Manos,

If it's always multiply, and always that format, try this

=LEFT(A1,FIND("*",A1)-1)*RIGHT(A1,LEN(A1)-FIND("*",A1))
 
Back
Top