Forum Discussion
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 :...
Hi Jos,
Both option is acceptable.
Thanks Frank
Both option is acceptable.
Thanks Frank
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