Link to home
Start Free TrialLog in
Avatar of slightlyoff
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!
ASKER CERTIFIED SOLUTION
Avatar of Runrigger
Runrigger
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of slightlyoff
slightlyoff

ASKER

You are great in many ways!

Thank you so much!