Forum Discussion
TRossi300
Aug 17, 2022Copper Contributor
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...
- Aug 17, 2022
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.
OliverScheurich
Aug 17, 2022Gold Contributor
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
Aug 17, 2022Copper Contributor
Perfect! Thank you!