Upper to Lowercase in Excel

[Beth]

Hi,

I have a spreadsheet with first and last name (column A), address 1 (column
B), address 2 (column C), City (column D), State (column E), Zip (column F).
All text is in uppercase. Is there a way to update all columns to Inital
Caps (upper/lower case)

 

[JuanMarin]

Hi,

you might want to try to PROPER() function for every cell, it will do
just what you need. HTH,

Juan Marin

 

[Mike H]

Beth,

Have a look at PROPER in Excel help.

Mike

 

[Beth]

Great, I see that function. Can I enter this function into a spreadsheet
that is already populated, or do I need to start new? Thanks!

 

[Mike H]

Beth,

=proper(a1) in b1 and dragged down would create a new column with your names
converted to proper case. This does what you want but you then have 2 columns
and can't delete the first because the formula refers to it so you can do
this.

You can copy the newly created column and then
select the original column
Edit|Paste special
paste values
delete the column with the formula in

Mike

 

[Beth]

Got it - thanks! Really appreciate the help!!!!!

 

[Gord Dibben]

Could you use a macro to change all at once without any formulas or helper
cells?

Sub Proper()
Dim Cell As Range
Application.ScreenUpdating = False
For Each Cell In Selection
Cell.Formula = Application.Proper(Cell.Formula)
Next
Application.ScreenUpdating = True
End Sub

Sub Upper()
Dim Cell As Range
Application.ScreenUpdating = False
For Each Cell In Selection
Cell.Formula = UCase(Cell.Formula)
Next
Application.ScreenUpdating = True
End Sub

Sub Lower()
Dim Cell As Range
Application.ScreenUpdating = False
For Each Cell In Selection
Cell.Formula = LCase(Cell.Formula)
Next
Application.ScreenUpdating = True
End Sub



Gord Dibben MS Excel MVP

 

[RUQRU]

Beth,

Try installing ASAP Utilities. it has many added functions for Excel,
including CASE change for text values. You can select a range and change to
UPPER, lower, Sentence or Title Case. No formulas needed.

See: http://www.asap-utilities.com/

It is FREE! Works with all versions through 2007. I love this tool.

P.S. I am just a user and have no connection to the author.