You can do without code. Use the formula
=A1 & " " & B1
in column C and copy down. Then copy the formula cells and do an edit,
paste special values back over the formulas. Then delete columns A and B
Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on
VB macros for Excel
"ub" wrote in message
...
Hi
I have data in approx 800 lines as:Column A Column B
Cook Mark
Jones Peter
Column A has last name, Column B has first name.
I want to joing data of 2 columns to show Firstname Lastname in ColumnA
and
then delete Column B
Please advise how to write this code