Multiply Function

[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

 

[Bob Phillips]

Manos,

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

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