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

swapping column info between 2 columns
 

Hazarding some thoughts ..

Assuming artists in col C, titles in col D, from row2 down
and assuming say, all titles' text carry a symbol, eg: @text1, @texxxt2, etc
which distinguishes these from artists' (text without @)

Then we could try something like this:

in E2:
=IF(ISNUMBER(SEARCH("@",C2)),D2,C2)

in F2:
=IF(ISNUMBER(SEARCH("@",C2)),C2,D2)

Select E2:F2, copy down. This will gather all text with @ in col F (titles),
and all text wo @ (artists') in col E. We could then copy cols E and F and
overwrite cols C and D with a paste special as values, then delete cols E and
F. If there's no way to distinguish between artists' text and titles' text,
then the only way is manual.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"rosy" wrote:
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 quick , not line by line
,,,thank you
Rosy