Thread: swap
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
shail shail is offline
external usenet poster
 
Posts: 195
Default swap

Hi Eli,

Thanks, it is great.

Shail


Eli Shichrur wrote:
USE "Ctrl" + "x" on The Source and "Ctrl" + "+" on the desteney

"Gary" wrote:

I want to swap values of two cells. can anyone help me on that? Eg. Cell A1
contains the value 20 & cell A2 contains the value 100. I want 100 on A1 &
20 on A2.

Thanks
Gary