Concatenating multiple rows in Excel

[Prexo]

Hello,
Does anyone have any idea how to concatenate multiple rows in excel? I have attached a sample of what I'm trying to do. I have a spreadsheet with duplicates in it. I identified the dups and now need to concatenate that into one column.

[JP Romano]

Hi - try putting this into cell G2

 =C2 & " - "& D2 & ", " & E2 & " Rental Months Remaining"

You can use a combination of cell references (C2, D2, E2) and literal text, which goes in quotation marks (" - "). Seperate each token with an ampersand.


If that works, you can just drag the formula down to the end of your range.

Good luck!