Overlaying columns

[Roger]

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

 

[FSt1]

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]

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

 

[Paul B]

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