Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I move data from one cell and add to another?
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? |
#2
|
|||
|
|||
Concatenate in a "new/inserted" C column.
"wntw" wrote in message ... 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? |
#3
|
|||
|
|||
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 SpecialValueOKEsc. Delete Columns A and B. Gord Dibben Excel MVP On Mon, 7 Mar 2005 16:01:02 -0800, "wntw" wrote: 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? |
#4
|
|||
|
|||
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. "Gord Dibben" wrote: 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 SpecialValueOKEsc. Delete Columns A and B. Gord Dibben Excel MVP On Mon, 7 Mar 2005 16:01:02 -0800, "wntw" wrote: 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? |
#5
|
|||
|
|||
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 ToolsOptionsEdit "Allow drag and drop". Gord On Tue, 8 Mar 2005 11:27:03 -0800, "wntw" wrote: 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. "Gord Dibben" wrote: 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 SpecialValueOKEsc. Delete Columns A and B. Gord Dibben Excel MVP On Mon, 7 Mar 2005 16:01:02 -0800, "wntw" wrote: 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? |
#6
|
|||
|
|||
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. "Gilles Desjardins" wrote: Concatenate in a "new/inserted" C column. "wntw" wrote in message ... 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? |
#7
|
|||
|
|||
From my first post......
Copy down column C as far as you need. Select Column C and copy. Then Paste SpecialValueOKEsc. Delete Columns A and B. The Paste SpecialValue is done in place on the selected Column C. That operation removes the formulas and leaves the names only. Gord On Tue, 8 Mar 2005 16:55:06 -0800, "wntw" wrote: 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. "Gilles Desjardins" wrote: Concatenate in a "new/inserted" C column. "wntw" wrote in message ... 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? |
#8
|
|||
|
|||
Thank you soooo much. It worked!!!. You saved me so much work. I appreciate
you taking the time to help. "Gord Dibben" wrote: From my first post...... Copy down column C as far as you need. Select Column C and copy. Then Paste SpecialValueOKEsc. Delete Columns A and B. The Paste SpecialValue is done in place on the selected Column C. That operation removes the formulas and leaves the names only. Gord On Tue, 8 Mar 2005 16:55:06 -0800, "wntw" wrote: 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. "Gilles Desjardins" wrote: Concatenate in a "new/inserted" C column. "wntw" wrote in message ... 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? |
#9
|
|||
|
|||
I'm happy that you're happy.
Thanks for the feedback. Gord On Tue, 8 Mar 2005 17:43:03 -0800, "wntw" wrote: Thank you soooo much. It worked!!!. You saved me so much work. I appreciate you taking the time to help. "Gord Dibben" wrote: From my first post...... Copy down column C as far as you need. Select Column C and copy. Then Paste SpecialValueOKEsc. Delete Columns A and B. The Paste SpecialValue is done in place on the selected Column C. That operation removes the formulas and leaves the names only. Gord On Tue, 8 Mar 2005 16:55:06 -0800, "wntw" wrote: 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. "Gilles Desjardins" wrote: Concatenate in a "new/inserted" C column. "wntw" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|