Learn Excel – Change Excel Case Part II: Podcast #1357

March 9, 2011 at 4:18 pm


One of the common Excel questions is how to change from lower case to upper case to proper case. Word offers a way to do this, but the steps in Excel are tougher. As I mentioned in yesterday’s Episode #1356 of the podcast, it is seven ugly steps to change a column of text to upper or lower or proper.

Today’s Episode #1357 of the podcast offers a 5-line macro that can convert text to upper case or lower case. Watch the 8-minute podcast for the complete set of steps, but here is the code that you can copy and paste into your Personal Macro Workbook.

Sub UpperSelection()
For Each cell In Selection
If Not cell.HasFormula Then
cell.Value = UCase(cell.Value)
End If
Next cell
End Sub
Sub LowerSelection()
For Each cell In Selection
If Not cell.HasFormula Then
cell.Value = LCase(cell.Value)
End If
Next cell
End Sub
Sub ProperSelection()
For Each cell In Selection
If Not cell.HasFormula Then
cell.Value = Application.WorksheetFunction.Proper(cell.Value)
End If
Next cell
End Sub

By the way, I usually classify as anything with a macro as complex, only for the top 20% of Excellers. However, the steps in the macro are designed to be easy for anyone to follow, even if you’ve never used macros before. If you regularly have to convert text from upper case to lower case or proper case, spending 10 minutes to follow these steps will dramatically improve your efficiency with these tasks.

"Learn Excel 97-2007 from MrExcel" by Bill Jelen…This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

“The Learn Excel from MrExcel Podcast Series”

For all of your Microsoft Excel needs visit MrExcel.com — Your One Stop for Excel Tips and Solutions.

Advertisements

Entry filed under: Excel 2010, Excel 2010 In Depth, Learn Excel 97-2007, Learn Excel from MrExcel, MrExcel Podcast, MrExcel Products, VBA and Macros. Tags: , , , , , , , , , , , , , , , , , , , , , .

Learn Excel – Changing Case in Excel Part I: Lower, Upper, Proper: Podcast #1356 The Lost Episode – Was it a ’68’ or ’78’?: Podcast #1358


Learn Excel from MrExcel

Learn Excel Podcast Splash Screen

The Excel Beginners Book:

"Don't Fear The Spreadsheet" - by Tyler Nash, Bill Jelen, Tom Urtis and Kevin Jones

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 738 other followers

Live Lessons Excel 2010 DVD

"Live Lessons Excel 2010" DVD

RSS MrExcel Recent Articles

  • An error has occurred; the feed is probably down. Try again later.

Recent MrExcel Tweets

MrExcel Podcast Archive


%d bloggers like this: