On Thu, 7 Aug 2008 08:55:01 -0700, Brad
wrote:

assume cell c4 has " alan parsons project"

in cell d4 =trim(c4) would remove the first spaces

At the same time

=proper(trim(c4)) would yield Alan Parsons Project - without the leading
spaces...

If you don't have numbers in your titles - you could simply find and replace
0 with nothing, then find and replace 1 with nothing ... find and replace 9
with nothing. If you have numbers in your titles - this method will get rid
of information you want to keep.

if you have numbers in your titles - is there something right afterthe track
number (like a "."? if so you can find and replace 0. with nothing .....

Still not got it yet, will work on it over the weekend, on where I am
supposed to put the commands you say.

Don't know how to thank you for your help, so here is a risky
south-london joke (the best I know at the moment) as some sort of
payment. Hope you like it, it reminds me of the times when I worked
for some bigger companies, where so complete ****s took the credit for
the company doing well.









Some years ago, Stan married an attractive woman, Marilyn, half his
age, in a small Cornish community. After several months, young Marilyn
complained that she had never climaxed during sex and according to her
Grandmother, all Cornish women are entitled to a climax once in a
while. So, to resolve the problem, they went to see the Veterinarian
since there was no trustworthy doctor anywhere in Truro.

The Vet didn't have a clue, but he did recall how, during the hot
summer, a farmer, would fan a cow that was having difficulty breeding,
with a big towel. This would cool her down and make her relax. So the
Vet told them to hire a strong, virile, young man to wave a big towel
over them while they were having sex. This, the Vet said, would cause
the young wife to cool down, relax, then climax. So the couple hired a
strong young man from Newquay to wave that big towel over them as the
Vet suggested. After many efforts, Marilyn still had not climaxed so
they went back to the Vet.
The Vet said for Marilyn to change partners and let the young man have
sex with her while Stan waved the big towel. They tried it that night
and Marilyn went into wild, screaming, ear-splitting climaxes, one
right after the other for about two and a half hours. When it was
over, Stan looked down at the exhausted young man and in a boasting
voice said:

scroll down.......




































'And that, my son, is how you wave a towel!'






Let me know if you found that funny.

Mark in Spain.