Forum Discussion

Copper Contributor

May 25, 2020

Calculable Text?

Hi Guys, Is there a possibility to turn the data in book 1 into a calculation? Example: Bourbon Vanilla : Dairy Ice Cream 2 x 5 ltr [2] The 2 x 5ltr should be 2*5ltr or Bloomer :...

developer

excel

Formulas and Functions

Macros and VBA

Jos_Woolley

Iron Contributor

May 25, 2020

Qkta6667

So what are your expected results here? Do you simply want to replace "x" with "*"? Or do you want to see the total weight/volume returned to another cell, i.e. (for your two examples): 10 ltr and 6300g?

Regards

Qkta6667
Copper Contributor
May 25, 2020
Hi Jos,
Both option is acceptable.
Thanks Frank
- Jos_Woolley
  Iron Contributor
  May 25, 2020
  Qkta6667
  
  Well, the first is very simple: if cell A1 contains
  
  2 x 5 ltr [2]
  
  then this formula in B1
  
  =SUBSTITUTE(A1,"x","*")
  
  will return
  
  2 * 5 ltr [2]
  
  Regards
  - Qkta6667
    Copper Contributor
    May 25, 2020
    Hi Jos,
    
    thanks for this, but now how can i turn this into a total volume in an another cell what can see the difference between Liter and Kilogram?
    
    Thanks
    Frank