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