Hi All,
I have 2 cells lets call them A2 and B2. They are the results of formulas and they are expressed in Fractions( See Below). I need to combine them in a 3rd column call it C2. With a * or a x between them. The simple version of this looks like =CONCATENATE(A2,"*",B2). but that doesn't work... It expresses the 2 values as Decimal and I need them to remain fractions ad displayed before. Any help would be greatly appreciated.
I have 2 cells lets call them A2 and B2. They are the results of formulas and they are expressed in Fractions( See Below). I need to combine them in a 3rd column call it C2. With a * or a x between them. The simple version of this looks like =CONCATENATE(A2,"*",B2). but that doesn't work... It expresses the 2 values as Decimal and I need them to remain fractions ad displayed before. Any help would be greatly appreciated.