Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
wntw
 
Posts: n/a
Default 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   Report Post  
Gilles Desjardins
 
Posts: n/a
Default

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   Report Post  
Gord Dibben
 
Posts: n/a
Default

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   Report Post  
wntw
 
Posts: n/a
Default

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   Report Post  
Gord Dibben
 
Posts: n/a
Default

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   Report Post  
wntw
 
Posts: n/a
Default

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   Report Post  
Gord Dibben
 
Posts: n/a
Default

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   Report Post  
wntw
 
Posts: n/a
Default

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   Report Post  
Gord Dibben
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 06:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"