Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
identify and move specific values
alright, i am super new to visual basic. i'm using excel 2003.
i have a list of values in column A. they look something like this: Record 1 of 678 AU: Artist Modest Mouse TI: Title This is a Long Drive for Someone with Nothing to Think About YR: Year 1996 KW: Keywords awesome; emo; cool; interpol LB: Label UP Records and so on for however many records there are. i want to convert this from one column, to several column. so, artists would be in one column, titles in the next, keywords in the next, etc. and i have a couple of problems. every field isn't available for every record. for example, the artist may be missing from one. or, every field isn't listed for every record. if there was some uniformity between records, i could handle this in Excel, but i feel like i need VB for this. is this too much to ask from a newbie? it's a little overwhelming, and i'm not sure even where to start! thanks for any help you can offer! sara |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I use a formula to identify WHICH row contains specific data? | Excel Worksheet Functions | |||
Identify the row with specific criteria | Excel Worksheet Functions | |||
formula to identify specific cells | Excel Discussion (Misc queries) | |||
Identify Blank Cells in Col & move coresponding data | Excel Programming | |||
Identify and move duplicate rows? | Excel Programming |