Here are the steps to follow in this lesson:
- Use the =PROPER() function to convert your text string.
- Look out for names like “Mckinley” – You will need to edit these cells manually by:
- Changing the cells from Formulas to Values using Copy, Paste Special, Values. Then edit each cell.
- 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.
Link to this post!
