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

=f2&" "&h2

--
Don Guillett
SalesAid Software

"Lillian" wrote in message
...
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

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

Jim Thomlinson


"Lillian" wrote:

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

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

"Lillian" wrote:

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

=f2&" "&h2



Lillian wrote:

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

--

Dave Peterson