Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a list of instruments that I'm trying to sort in alphabetical order
from left to right. The list is part of a larger database, where each row pertains to a specific song. I'm trying to get my list of instruments to be in alphabetical order on each line individually. I have about 40 columns of different instruments, and 50,000 rows, each record is unique, but some contain similar data. So what I have right now might look something like this: Acoustic Guitar Strings Electric Guitar Bass Percussion and I want it to look like this: Acoustic Guitar Bass Electric Guitar Percussion Strings I'm just trying to find a formula, or VB script that I can run to do this automatically. I'm not very experienced with VB, so I'm not even sure if this is possible, but I've exhausted google, and have come up with nothing that works. Any help is very very much appreciated!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Splitting rows into individual columns | Excel Discussion (Misc queries) | |||
Individual record spans multiple rows | Excel Worksheet Functions | |||
Exporting individual rows to Word | Excel Worksheet Functions | |||
How to turn rows horizontally to form columns? | Excel Worksheet Functions | |||
How do I Time stamp individual rows in excel? | Excel Discussion (Misc queries) |