Using the find/replace all feature of Excel (Excel 2007 labels this
"Find&Select")

Just don't enter anything in the "replace with" line and that will get rid
of the trebles and the .zip - make sure that you select the appropriate range
(or the entire worksheet)

If you use the =trim() function that will get rid of leading spaces.....

--
Wag more, bark less


"Anti-Spam" wrote:

I am trying to create a book listing my record/karaoke collection in
Excel, from the file names on my hard drive.

So far, I went to the command prompt in DOS, did a DIR to txt file
listing.

Have now manipulated this "txt" data into disk number, artist name and
track name in columns in Excel, but want to clean up the individual
cells. Here is what I would like to achieve.

1. A lot of the cells have a treble quotation leading in front on the
artists name for example, it would be nice if I could remove these
automatically (there are thousands).

2. Also a lot of leading spaces

3 If possible I would like to remove the trailing ".zip" ending from
the cells, again automatically

Please could someone help me thank you.

Mark.