looking for formula , single cell two numerical values , multiply in different columns

[land_land]

Hi,

im looking for formula , single cell two numerical values , multiply in different columns

example :

Cell (A1) contain: =350,23+25,59 (two values in a single cell)

request:

in (B2) only first value so 350,23 multiply (x) by fixed number &in (C2) only second value so 25,59 multiply (x) by fixed number

is there any way to do this

thank you

 

[Gerald Higgins]

Having two values in a single cell is rarely a good idea.

If you HAVE to do this, it might be possible . . .

Are they stored as a text string, or as a formula ?
If a text string, then it's fairly straightforward, you just need to work out a consistent method of identifying which part of the string is the first value, and which is the second - it looks like you can use the "+" symbol as the divider.
If your data is stored as a formula, then I'm afraid I don't know how to do it.

 

[XOR LX]

Cross-posted:

lookinf for formula , single cell two numerical values , multiply in different columns