Forum Discussion
Paddy_O
Sep 17, 2022Copper Contributor
Combining information from 3 cells into One - Street Address Issue
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 on...
NikolinoDE
Sep 17, 2022Platinum Contributor
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
Hope I was able to help you with this information.
I know I don't know anything (Socrates)