Hi Derek,
You could use a macro and change it all at once in place, even
making corrections for words that you do not want capitalized
within a title, words like my lastname where the capitalization
differs, names like IBM all in capitals, of course your exceptions
comes down to knowing your own data but it beats manual changes
or just using application.Proper in within a macro alone.
http://www.mvps.org/dmcritchie/excel/proper.htm

---
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

"Derek Y via OfficeKB.com" <forum@OfficeKB.com> wrote in message news:52057563676DD@OfficeKB.com...
>
> That works. Thanks
>
> Adrian M wrote:
> >In Excel there are the UPPER, lower and Proper functions which allow you to
> >change cases. If I understand you correctly you would be looking to use the
> >Proper function. You can view video clips on using these functions on
> >http://www.auditexcel.co.za/text.html .
> >
> >> Is there a way, without copying and pasting my data to word and then
> >> formatting it in title case, to get my data to stay in excel but in title
> >[quoted text clipped - 6 lines]
> >> (reason i dont want to copy and paste is becuase i have two sheets each that
> >> are 13 columns wide and 60,000 rows)
>
>
> --
> Message posted via http://www.officekb.com