View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rosy rosy is offline
external usenet poster
 
Posts: 1
Default swapping column info between 2 columns

i have a listing of music and i have several rows that need to be swapped
between the 2 columns. ie. artist and title listing but on some lines the
title is in the artist place and the artist place is in the tittle place is
there an easy way to do the whole excel document queick , not line by line
,,,thank you
Rosy