Lewis
Assume first name in Column A and last name in Column B
In C2(assumes A1 and B1 are titles) enter =A2 & " " & B2
Double-click on the fill handle at bottom right corner of C2 to replicate down
column C.
When happy with results, copy Column C and in place Paste
SpecialValuesOKEsc.
Type Contact in C1 then delete columns A and B
Gord Dibben Excel MVP
On Thu, 2 Dec 2004 16:19:55 -0800, "Lewis Shanks"
wrote:
I have over 900 contacts which includes contact data containing two columns
of data, first name and last name, and wish to do the following:
move the last name to the first name column with a space between the first
and last name and then rename the column to be named contact.
Suggestions?
Thanks very much
Lewis Shanks
|