multiplying two numbers

[shimaa01234]

A process of multiplying two numbers after separated from the text
I want a formula in column "D", to achieve the result in it

[XOR LX]

Hi.

Not sure I understand. Sometimes the desired result is achieved by also including the column B value in the multiplication; sometimes it isn't.

Can you clarify?

Regards

[rajeshturaha]

Plz explain your requirement with an example

[shimaa01234]

Mr professorial "XOR LX"
I want a formula in column "d" It make multiplication the numbers between texts
If a single figure without text, multiplying in the cell in column "B"

[rajeshturaha]

try

Please Login or Register  to view this content.

in D or E col and drag it down

[shimaa01234]

Thank you very much, Mr. "rajeshturaha"
But I use Office 2003

[XOR LX]

If there are two values in column C, are they always separated by a linebreak?

Also, are the two text entries in those cases always "L.S" and "D"?

Regards

[rajeshturaha]

For 2003

Please Login or Register  to view this content.

[shimaa01234]

The formula works like a charm.
God bless you
Thank you very much, Mr. "rajeshturaha"
On this wonderful solution

[samba_ravi]

=IF(ISTEXT(C3),LOOKUP(9^9,LEFT(C3,ROW(INDIRECT("1:"&LEN(C3))))*1)*LOOKUP(9^9,RIGHT(TRIM(SUBSTITUTE(C3,"D","")),ROW(INDIRECT("1:"&LEN(C3))))*1),C3*B3)
Try this and copy towards down

[shimaa01234]

Yes Mister "XOR LX"
Thank you very much for your participation
Because this is an honor for me

[shimaa01234]

Mister "Siva"
This is too much for me, a genius solution
God bless you

[rajeshturaha]

Glade it helped you.
If you have your desired result plz mark this thread as solved.
Click * to add to reputation whose answer helped you

[samba_ravi]

Mister "Siva"
This is too much for me, a genius solution
God bless you

Thanks for your feedback and adding reputation