Combining information from 3 cells into One - Street Address Issue

Question

I get a spreadsheet every day with the number of the address in one column the name of the street in another column and the city in 1/3 column and I'd like to take all of this data and put it into one cell without having to copy and paste it. How can I get the three fields merged into one?

nikolinode · Answer

Paddy_O&nbsp;Combine text from two or more cells into one cellYou can combine data from multiple cells into a single cell using the Ampersand symbol (&amp;) or the CONCAT function.&nbsp;A1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C1112 &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Homer &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Athen&nbsp;formula:&nbsp; =A1&amp;" "&amp;B1&amp;" "&amp;C1&nbsp; &nbsp;or&nbsp; =CONCAT(.&nbsp;&nbsp;Hope I was able to help you with this information.&nbsp;NikolinoDEI know I don't know anything (Socrates)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

Forum Discussion

Combining information from 3 cells into One - Street Address Issue

1 Reply

Resources