Hi Andy,
If you would prefer to do it all in the same text column(s) you would be
better using a macro, and it would be a lot faster to use
once you've set up some macros. Then you can select the entire column
and convert it -- macro should be restricted to the used range and use
of special cells will limit such selections by definition so that the user
doesn't have to be concerned with limiting range of selection.
Proper, and other Text changes -- Use of SpecialCells
http://www.mvps.org/dmcritchie/excel/proper.htm

You would get more out of newsgroups if you posted directly to newsgroups
rather than through a web page, and if you searched Google and Google
Groups before posting. Use of "forums" messes up web searching for
all users by duplicating what is posted in newsgroups. .
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"andy_" wrote in message
...

great stuff,
Thanks very much.