Concatenate acting funky

[Hayley]

I was recently upgraded to Excel 2010 so maybe that's why I can't figure this out, but I have 2 columns that contain address information. Column A is 123 Stone Street. Column B is Apt. #4. I want Column C to comibine them into one cell: 123 Stone Street Apt. #4.


I tried =concatenate(A1,B1) and the results literally said: =concatenate(A1,B1)


Help? How do I get it to actually perform the function?

 

[Dhamo]

Hi Hayley,


Try this in column c.


=a1&" "&b1

 

[Dhamo]

Assuming your values are at first row. Please change the row number according to your data.

 

[Hayley]

Thanks Dhamo. But no, the result was just to show exactly in the cell =a1&" "&b1

 

[Dhamo]

You mean, C1 is displaying this (=a1&" "&b1) instead of 123 Stone Street Apt. #4.? if yes, please disable viewing the formulas(Excel menu - Formulas - Show formulas).


If I am wrong, please post a sample file to analysis further.


=a1&b1 will do the same as what concatenate(A1,B1) will do.


To add a space between two address I used this (&" ")

 

[shrivallabha]

Hi Hayley,


Try this if Dhamo's suggestion doesn't work out.


1. See how the cell has been formatted by pressing CTRL + 1

2. If it is set to 'TEXT' then change it to 'GENERAL'.

3. Then press F2 followed by ENTER.

 

[Hayley]

Oh...that was it...the data was in TEXT format.


Thank you both for your help.