ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   swapping data from 2 separate columns (https://www.excelbanter.com/excel-discussion-misc-queries/71884-swapping-data-2-separate-columns.html)

Johnny D

swapping data from 2 separate columns
 
I have data in column B and data in column F. How do I swap the two columns?

Peter Ellis

swapping data from 2 separate columns
 
Select column B (using the column header at the top) and cut to the
clipboard. Paste in some blank column.

Select column F and cut to the clipboard. Paste into column B

Cut the original column B whereever you put it and copy into F.


"Johnny D" wrote:

I have data in column B and data in column F. How do I swap the two columns?



All times are GMT +1. The time now is 02:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com