Forum Discussion
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 function?
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.
7 Replies
- That doesn't work
- 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?
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.
