We help IT Professionals succeed at work.

Excel 2007, combine text and formula in one cell

slightlyoff
slightlyoff asked
on
Medium Priority
295 Views
Last Modified: 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.

Thanks!
Comment
Watch Question

This should do it

=concatenate("US:MI:",I2*0.06)

Author

Commented:
You are great in many ways!

Thank you so much!

Explore More ContentExplore courses, solutions, and other research materials related to this topic.