Overlaying columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
I figured out a way to do it, using the "Copy" and "Paste Special" functions,
through trial and error. Thanks!
 
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
 
Back
Top