Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Data From One Column into Multiple Columns | Excel Worksheet Functions | |||
Sum up columns in different sheet with error check | Excel Discussion (Misc queries) | |||
Summing one column if two other columns' values appear in other sh | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |