Hi all,
I am trying to use the CONCATENATE OR & FUNCTION IN Excel 2007, but is is not showing the results only the formula. What do i need to do to display the results.
I have three colums of data trying to combine Columns B and C into Column D . I tried the following but its not working. Please advise.
Formula
=B1&C1
=CONCATENATE(B1,C1)
I also tried using CTRL + the Grave accent per excel help, but that did not work either.
Thank you.
Make sure your cell format is not "Text"
It is possible that you have your columns formatted as text...you'll have to move your formulas....format as general then put the formulas back....there are other ways to fix it also....HTH
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
Sounds like the cell is formatted as TEXT.
Change the cell format to General then re-enter the formula.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
JieJenn,
Thats exactly what the issue is. However, I need my fields to be text or formatted similiar to text because some of the data starts with a "0" and the leading zero is removed if I use general. Is there a way of getting around this.
For example
Column B 01234 and Column C is ZZ. I need column D to show 01234ZZ. When I format it as genral I get the following Column B 1234 Column C ZZ and Column D 1234ZZ.
Thank you so very much-!!
Still format the cell with the formula as General.
Apply the TEXT function to Column B within the concatenate function to preserve the leading 0
=TEXT(B1,"00000")&C1
Then you need to format column B as TEXT. Does column B contain a formula that returns 01234?
Excel doesn't like numbers with leading zeros!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks