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

Hi,

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

Juan Marin

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!
--
Beth


"JuanMarin" wrote:

Hi,

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

Juan Marin

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" wrote:

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!
--
Beth


"JuanMarin" wrote:

Hi,

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

Juan Marin

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


"Mike H" wrote:

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" wrote:

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!
--
Beth


"JuanMarin" wrote:

Hi,

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

Juan Marin

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



On Tue, 15 Jul 2008 11:30:00 -0700, Beth wrote:

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

Beth,

Have a look at PROPER in Excel help.

Mike

"Beth" wrote:

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

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.

"Beth" wrote:

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