Move data from one colum to another

  • Thread starter Thread starter Lewis Shanks
  • Start date Start date
L

Lewis Shanks

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
Special>Values>OK>Esc.

Type Contact in C1 then delete columns A and B

Gord Dibben Excel MVP
 
Back
Top