macro using PROPER function

[CLew]

Dear all,

I have a Excel sheet with 13,000 names and address that are all i
upper case. Is there way to automate the Proper function so that th
cases are corrected? That is, the first character of the first an
last names is in upper case and rest in lower case. I'm rather new t
using macros in Excel.

Thanks in advance!
-Chri

 

[Frank Kabel]

Hi
see:
http://www.mvps.org/dmcritchie/excel/proper.htm

 

[Stephen Rasey]

This sounds like a one time job.
Do not use a macro.
Assuming Names and Addresses are in columns A & B
Insert two columns at C
In the new C =Proper(A1)
In the new D =Proper(B1)
Select C11, Copy Down.
Select C, Copy, Paste Special Values.
Inspect and edit.
Delete Columns A:B

Stephen Rasey
Houston
http://wiserways.com
http://excelsig.org

 

[Bob Phillips]

Chris,

Here is some simple code

Dim cell As Range

For Each cell In Selection
cell.Value = WorksheetFunction.Proper(cell.Value)
Next cell

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[CLew]

Thanks to all of you for the suggestions. I followed Stephen's advic
regarding pasting special values into new columns since it seemed th
easiest. But I'll definately keep all of it on record for the nex
time I get set of lists from the distributor!

All the best,
Chri