MP3 files and Excel spreadsheet

I have a file on my desktop called "magmusic". it contains over 700 songs.
how do i list them alphabetically in an Excel spreadsheet.
EX. TITLE ARTIST
ANY HELP WOULD SURELY BE APPRECIATED. THANKS.

Try the attached link

http://www.j-walk.com/ss/excel/tips/tip103.htm

VBA Noob

What file format is the file on your desk top?

you could try and 'Data'.....'Data import'....follow the steps to import the
data into excel once you have it in it should just be a matter of doing a
'data'...'sort' using the song title as the key sort field.

"[email protected]" wrote:

> I have a file on my desktop called "magmusic". it contains over 700 songs.
> how do i list them alphabetically in an Excel spreadsheet.
> EX. TITLE ARTIST
> ANY HELP WOULD SURELY BE APPRECIATED. THANKS.

I'm betting it is not a "file" but rather a "folder".

Noob has given you a good link to John's site.


Gord Dibben MS Excel MVP

On Mon, 17 Jul 2006 12:04:01 -0700, [email protected]
<[email protected]@discussions.microsoft.com> wrote:

>I have a file on my desktop called "magmusic". it contains over 700 songs.
>how do i list them alphabetically in an Excel spreadsheet.
>EX. TITLE ARTIST
>ANY HELP WOULD SURELY BE APPRECIATED. THANKS.

I'm betting it is not a "file" but rather a "folder".

Noob has given you a good link to John's site.


Gord Dibben MS Excel MVP

On Mon, 17 Jul 2006 12:04:01 -0700, [email protected]
<[email protected]@discussions.microsoft.com> wrote:

>I have a file on my desktop called "magmusic". it contains over 700 songs.
>how do i list them alphabetically in an Excel spreadsheet.
>EX. TITLE ARTIST
>ANY HELP WOULD SURELY BE APPRECIATED. THANKS.

I'm betting it is not a "file" but rather a "folder".

Noob has given you a good link to John's site.


Gord Dibben MS Excel MVP

On Mon, 17 Jul 2006 12:04:01 -0700, [email protected]
<[email protected]@discussions.microsoft.com> wrote:

>I have a file on my desktop called "magmusic". it contains over 700 songs.
>how do i list them alphabetically in an Excel spreadsheet.
>EX. TITLE ARTIST
>ANY HELP WOULD SURELY BE APPRECIATED. THANKS.

I'm betting it is not a "file" but rather a "folder".

Noob has given you a good link to John's site.


Gord Dibben MS Excel MVP

On Mon, 17 Jul 2006 12:04:01 -0700, [email protected]
<[email protected]@discussions.microsoft.com> wrote:

>I have a file on my desktop called "magmusic". it contains over 700 songs.
>how do i list them alphabetically in an Excel spreadsheet.
>EX. TITLE ARTIST
>ANY HELP WOULD SURELY BE APPRECIATED. THANKS.