Title Case--No mail merge

  • Thread starter Derek Y via OfficeKB.com
  • Start date
D

Derek Y via OfficeKB.com

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

Derek Y via OfficeKB.com

That works. Thanks

Adrian said:
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
Click to expand...
[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)
Click to expand...
Click to expand...
 
D

David McRitchie

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 said:
That works. Thanks

Adrian said:
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
Click to expand...
[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)
Click to expand...
Click to expand...
Click to expand...
 
Top