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

W

wntw

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?
 
G

Gord Dibben

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
 
W

wntw

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.
 
G

Gord Dibben

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
 
W

wntw

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.
 
G

Gord Dibben

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
 
W

wntw

Thank you soooo much. It worked!!!. You saved me so much work. I appreciate
you taking the time to help.
 

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

Automation of scanned file storage based on content 0
Moving info from rows to columns 2
Critical - Converting Single Column Address Data into Multiple Col 2
Varying cell ranges in formulas according to number of cells with certain value 1
Need a proper guru! My head hurts ;( 1
Splitting Text from single cell in column across multiple Columns 3
a data validation list that contains a list of named ranges - not alist from a named range 1
Creating list from values that meet multiple criteria from other sheet 1

Top