How do I move data from one cell and add to another?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to set up a mailing list for my business. The company I use needs
the the first and last name to be in 1 cell, the street address in the second
cell, the city in the 3rd, the state in the 4th, and the state in the 5th. My
list I got has the 1st name in cell A, the last name in cell B.and etc. How
do I take the data from B and add to A?
 
Insert a column right of B.

Enter this formula in C1

=A1 & " " & B1

Copy down column C as far as you need.

Select Column C and copy. Then Paste Special>Value>OK>Esc.

Delete Columns A and B.


Gord Dibben Excel MVP
 
I don't know if I'm doing it right because so far, it hasn't worked. It will
change the 1st one ok but do I copy the same formula for all 554 names I
have? I must be doing something wrong.
 
Hover your mouse pointer over the lower right corner of the cell with the
formula. I am assuming C1.

You will see a black cross appear. Click on that and drag the cell down the
column until you get to 554.

The formula will change to =A2 & " " & B2, then =A3 & " " & B3

Or just double-click on the fill handle(black square at lower right) to
increment down the column.

If you don't see a black cross or fill handle, go to Tools>Options>Edit "Allow
drag and drop".


Gord
 
Ok, that worked, I have the first and last name in the new column c. If I
clear A, the name that was in A also clears from C.
 
From my first post......
Copy down column C as far as you need.

Select Column C and copy. Then Paste Special>Value>OK>Esc.

Delete Columns A and B.
Click to expand...

The Paste Special>Value is done in place on the selected Column C.

That operation removes the formulas and leaves the names only.


Gord
 
Thank you soooo much. It worked!!!. You saved me so much work. I appreciate
you taking the time to help.
 
You must log in or register to reply here.

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Seperating information in a cell 9
Critical - Converting Single Column Address Data into Multiple Col 2
Moving info from rows to columns 2
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Excel How to add numbers in same cell? 2
move text from one cell to another 4

Back
Top