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
  - Jos_Woolley
    Iron Contributor
    May 25, 2020
    Qkta6667
    
    Ah, so then that first solution was not in fact an option for you. Are you now saying that in fact my second proposal is what you require, i.e. to return 10 ltr and 6300g?
    
    If so, can you clarify the precise nature of the cell contents? For example, do they always have a number in square brackets at the end, e.g. [2], [7]? Is this value to be taken into consideration, or ignored?
    
    Also, what version of Excel are you using?
    
    Regards