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