EXcel Help - Merging columns

Thundyrkatz

Hello H/A!

I have an excel report that has text data in 2 columns that i need to have in one column, does anyone know if it is possible to make this happen?

Here is an example of what i am talking about...

Current Column 1........Current Column 2
Joe..............................Smith
Jane.............................Doe

Desired Column
Joe Smith
Jane Doe

Thanks in advance for any help you can offer!

Deebaser

Either use the concatenate function or put this formula in C2:
=A2 & ' ' & B2

Assuming Column A is first Name and Column B is Second Name. If you no longer need the unmerged data, just copy it and "paste special" as values.

LaOs

Yeah, deebs is right on here; use CONCATENATE(A1," ",B1) to get "Joe Smith" in C1 and then fill down.

Thundyrkatz

Holy Cow! That's so simple! You guys are amazing, thank you so much!