If I understand, you have last in col a, first in col b and you want both in
col c. You probably should have been able to figure this out yourself.
c.offset(,2) = c & ", " & c.Offset(, 1)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Darrell_Sarrasin via OfficeKB.com" <u33691@uwe wrote in message
news:8aae6e304f5cf@uwe...
can this be manipulated so the results show in column c and does not
effect
the first name?

Don Guillett wrote:
Sub lastfirst()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
lastrow = Cells(Rows.Count, "a").End(xlUp).Row
For Each c In Range("a2:a" & lastrow)
c.Value = c & ", " & c.Offset(, 1)
Next c
Application.ScreenUpdating = False
Application.Calculation = xlCalculationAutomatic

End Sub

I am creating reports from a precreated excel document. my boss wants me
to
[quoted text clipped - 3 lines]
doc
would not be bad but we have 10000 entries in the form. please help.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200809/1