Multiply Function
 

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

Multiply Function
 

Manos,

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

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

--

HTH

Bob Phillips

"Manos" wrote in message
.. .
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