slightlyoff
asked on
Excel 2007, combine text and formula in one cell
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.
Thanks!
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.
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you so much!