ExcelBanter - How to swap contents between 2 cells in MS Excel 2003?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to swap contents between 2 cells in MS Excel 2003? (https://www.excelbanter.com/excel-discussion-misc-queries/160974-how-swap-contents-between-2-cells-ms-excel-2003-a.html)

Dhanu

How to swap contents between 2 cells in MS Excel 2003?

Dave Peterson

How to swap contents between 2 cells in MS Excel 2003?

Move the first into a temporary cell.
Move the second into the original first location.
Move the temporary into the original second location.

Nothing built into excel to make it easier.

Dhanu wrote:

--

Dave Peterson

All times are GMT +1. The time now is 02:46 AM.