Cell merge help

[thomashandlon99]

I am hoping i can do this. Does anyone know how I can merge two columns toghther and keep the data in both columns?
I have an address issue when the data was converted to excel it put the numbers part of the address in column "C" and the stree name in column "D"

[6StringJazzer]

Welcome to the Forum! That's the first time I've ever seen a post count of 0.

In E1 (or the first row of any available column) use this formula

=C1 & " " & D1

then copy down. If you don't want to keep the original two columns, then select the entire column E, copy, paste special values, and then delete C and D.

[thomashandlon99]

Thank you that worked great