Move data from one colum to another

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Formula To Split Name 5
Split Data in One Column Into Two 2
Import data from one file to another 1
VBAscript for data matching excels 0
Select & Move Range 4
Combining first and last names 1

Top