Is there a way to overlay data in one column to another without replacing
data in original column? I have 10 sets of 1500 rows that I need to overlay
but not replace any data in either column (if that makes sense).

Roger, maybe in another column, =A2&B2 is this what you want?
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Roger" wrote in message
...
Is there a way to overlay data in one column to another without replacing
data in original column? I have 10 sets of 1500 rows that I need to
overlay
but not replace any data in either column (if that makes sense).

I figured out a way to do it, using the "Copy" and "Paste Special" functions,
through trial and error. Thanks!

"Paul B" wrote:

Roger, maybe in another column, =A2&B2 is this what you want?
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Roger" wrote in message
...
Is there a way to overlay data in one column to another without replacing
data in original column? I have 10 sets of 1500 rows that I need to
overlay
but not replace any data in either column (if that makes sense).

hi,
explained the way you have explained, i am having trouble grasping the
logic. perhaps hiding one column might be a work around as a pseudo overlay???
Post back with more detail.
Regards
FSt1

"Roger" wrote:

Is there a way to overlay data in one column to another without replacing
data in original column? I have 10 sets of 1500 rows that I need to overlay
but not replace any data in either column (if that makes sense).