LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 367
Default convert files to text

This issue is related to music. I am having trouble adding folders to a
library--roughly 1/2-3/4 of the files are importing. Because of the numbers
(8000+ songs) it's not practical to go through them manually to find the
tracks that did not import properly.

I want to create 2 sheets--one with the tracks in my music library, the
other with the files in the folder that it's importing from..so I can find
duplicates & see the records that did not import.

Now (finally) to the question--is there a way to take all of the files in
windows explorer & convert the file names to text so that I can paste them
into Excel? I tried to copy & "paste special" as text, but it doesn't work.

Any ideas???
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import multiple text files (Macro) Thr33of4 Excel Discussion (Misc queries) 0 September 19th 06 02:19 AM
Numeric in Text to convert back to the form of Numeric for VLookup Purposes achilles Excel Discussion (Misc queries) 4 February 6th 06 07:05 AM
Text to time convert Rudo Excel Discussion (Misc queries) 2 November 14th 05 01:00 AM
Convert text numbers to numbers Barb Excel Worksheet Functions 4 October 22nd 05 07:18 PM
importing multiple text files URGENT!!! HELP tasha Excel Worksheet Functions 0 December 19th 04 04:26 PM


All times are GMT +1. The time now is 10:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"