exchange content of cells

[\jeremy via OfficeKB.com\]

If i have 2 cells (or groups of cells) is there a way to exchange the
contents or do I have to copy/paste the first contents into empty cell, then
copy/paste second contents into first cell, etc, etc....

Thanks.

Jeremy

 

[Guest]

Take a look at:

http://www.mvps.org/dmcritchie/excel/swap.htm