Move data from one colum to another
 

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

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