combine info in several cells into one cell
(SOLVED)
Hello,
I have been given a bunch of addresses and they are split into different cells. Example "123 abc st" in one cell, "spartanburg" in another cell, "SC" in another cell and the zipcode in a 4th cell. I would like to combine all of the information so that it shows the full address in one cell. I should add that they are in seperate columns also.
Thank you.
Last edited by double a enterprises; 07-25-2010 at 11:32 AM.
Attached excel file containing the formula which can be used to combine all the address into one cell. The formula is in cell F2 in the sheet named "Sheet1".
You can add more address in column A, B,C,D and then drag the formula in column F to combine all the addresses.
Let me know if you face any problem. Thanks.
Also you can use the CONCATENATE function. It will do the same thing as the "&" in queryak's formula [e.g. =CONCATENATE(text1,text2,text3)] and so the modified formula would be:
Both options should give you the same results. Its your choice in picking one style that works for you.
Please Login or Register to view this content.
Good luck.
abousetta
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks