Excel 2007, combine text and formula in one cell
Posted on 2012-03-13
So here's the deal...
Google wants tax info in the text file we send for our Google Feed.
The format is US:MI:1.00 - where the 1.00 is the tax amount.
1:00 can be found by multiplying .06 * the values in column "I"
if I do this - =SUM(I2*0.06) &":US:MI" it works, but the price is before the text.
Is there a way to do the formula after text?
I've tried a few things with no success.