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

@Paddy_O 

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   

or

  =CONCAT(.

 

 Hope I was able to help you with this information.

 

NikolinoDE

I know I don't know anything (Socrates)