Merging 2 columns without using reference

[zenofex73]

Hey everyone,

Right now, I am using =A1&" "&B1 to merge 2 columns to form one column. However, for this to work, I need both A and B columns to exist. However, I want to be able to merge both columns to form a new column, and then be able to delete both A and B. How would I be able to do this without manually copying and pasting each cell in A and B?

I am not sure if my explanation is good enough, so I'll give an example:

There are 2 columns A and B. A stores first names, and B stores middle initials.

A B
Rick M
Tom GY
Bill B

Basically, I would like to merge columns A and B into a new column (C) that looks like:

C
Rick M
Tom GY
Bill B

I can already do this with =A1&" "&B1, but the problem is I want to be able to get rid of A and B columns once I get column C to work.

I hope my illustrations make sense and I would appreciate any help regarding this question.

Thanks in advance,

Z

[VBA Noob]

Select column C and paste special > values then delete Col A and B

http://www.bettersolutions.com/excel...I216522111.htm

VBA Noob