Forum Discussion

Copper Contributor

Aug 17, 2022

Solved

Need to combine names down 2 columns

I'm fairly new to using Excel for this purposes. I need some help with the CONCAT function. I have 400+ Names I need to combine in column c from columns A and B. What is the best way to apply this fu...

Formulas and Functions

OliverScheurich
Aug 17, 2022
TRossi300
The formula can be filled down for as many rows as required. The screenshot shows the result after filling down the formula from cell C1. In column D you can see the formula of the adjacent cell in column C. An alternative is to drag the formula from C1 down as required.

TRossi300

Copper Contributor

Aug 17, 2022

similar yes, that is good for a single row, is there a faster way to combine rows 2-438 than just copying that out again and adding the current row?

OliverScheurich

Gold Contributor

Aug 17, 2022

TRossi300

The formula can be filled down for as many rows as required. The screenshot shows the result after filling down the formula from cell C1. In column D you can see the formula of the adjacent cell in column C. An alternative is to drag the formula from C1 down as required.

Maplewynd
Copper Contributor
Nov 19, 2022
No that I have done this, how do I keep combined information and get rid of the first 2 columns?
- OliverScheurich
  Gold Contributor
  Nov 20, 2022
  Maplewynd
  Assuming the concatenated values are in cells C1:C25. The concatenated ranges are A1:A25 and B1:B25 like in the screenshot of my last reply. Then copy range C1:C25 and paste only values. It's up to you if you then want to delete range A1:B25.
TRossi300
Copper Contributor
Aug 17, 2022
Perfect! Thank you!