Merge two column in one

[Guest]

I have one huge excel spreed sheet, on the column F is "First Name", on the
column H is "Last Name", example
F H I
Aram Smith Aram Smith

I would like on Column I showing first name last name like "Aram Smith"
How do you doing with macro?

Thanks.

Lillian

 

[Don Guillett]

=f2&" "&h2

 

[Guest]

Why not jsut use a Formula, something like this

=F2 & " " & H2

If you want at the end you can just copy and paste special Column I as
values to remove the formulas and leave the text.

 

[Guest]

Hi Lillian,

Assumes data starts in row 2:

Sub JoinNames()
Dim lastrow As Long, r As Long
lastrow = Cells(Rows.Count, "F").End(xlUp).Row
For r = 2 To lastrow
Cells(r, "I") = Cells(r, "F") & " " & Cells(r, "H")
Next r
End Sub

HTH

 

[Dave Peterson]

=f2&" "&h2

I have one huge excel spreed sheet, on the column F is "First Name", on the
column H is "Last Name", example
F H I
Aram Smith Aram Smith

I would like on Column I showing first name last name like "Aram Smith"
How do you doing with macro?

Thanks.

Lillian