Thread: swap
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JMB JMB is offline
external usenet poster
 
Posts: 2,062
Default swap

Select cell A1. Type in 100. Hit Enter.
Same process for cell A2.


"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