close

=A1*B1
A1 contains quot;bla bla $15.75quot;....B1 contains quot;20quot;
I need the quot;bla blaquot; ignored and the answer of $15.75*20--
jwfakouri
------------------------------------------------------------------------
jwfakouri's Profile: www.excelforum.com/member.php...oamp;userid=31435
View this thread: www.excelforum.com/showthread...hreadid=511272Try this formula in C1:

=VALUE(RIGHT(A1,LEN(A1)-FIND(quot;$quot;,A1))) * B1

Format as currency with 2 dp and copy down as necessary. Assumes you
will always have a $ before the numbers.

Hope this helps.

Pete

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄