Need to combine names down 2 columns

[TRossi300]

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?

[#2]

@TRossi300 

=CONCATENATE(A1," ",B1)

Is this similar to what you are looking for?

 

[#3]

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?

[#4 · Accepted solution]

@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.

[#5]

Perfect! Thank you!

[#6]

No that I have done this, how do I keep combined information and get rid of the first 2 columns?

[#7]

That doesn't work

[#8]

@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.