Combining information from 3 cells into One - Street Address Issue

Occasional Visitor

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?

1 Reply


Combine text from two or more cells into one cell

You can combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function.


A1             B1                    C1

112          Homer             Athen


formula:  =A1&" "&B1&" "&C1   




 Hope I was able to help you with this information.



I know I don't know anything (Socrates)