Title Case--No mail merge

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

Thanks,

Derek

(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 OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200507/1

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 .

"Derek Y via OfficeKB.com" wrote:

>
> 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
> case?
>
> Thanks,
>
> Derek
>
> (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 OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...excel/200507/1
>

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

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