Use the proper text function to change the case

Here are the steps to follow in this lesson:

  1. Use the =PROPER() function to convert your text string.
  2. Look out for names like “Mckinley” – You will need to edit these cells manually by:
  3. Changing the cells from Formulas to Values using Copy, Paste Special, Values. Then edit each cell.
  4. Before deleting a column of data, be sure to change the cells from Formulas to Values.

Find the video lesson that you want – Index to all Excel Topics

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

Speak Your Mind

*