Solved

Excel 2007, combine text and formula in one cell

Posted on 2012-03-13
2
258 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!
0
Comment
Question by:slightlyoff
2 Comments
 
LVL 11

Accepted Solution

by:
Runrigger earned 500 total points
ID: 37715554
This should do it

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

Author Closing Comment

by:slightlyoff
ID: 37715567
You are great in many ways!

Thank you so much!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
iPhone excel activation issues 11 69
consolidate from multiple folders 5 39
Macro 6 50
Google Sheets - Artificial Intelligence 2 6
Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now