PROPER function in Excel

[Bill]

I have a database of names and addresses that are all
upper case. I want to change them all with the PROPER
formula by applying it to entire colums of text, but I
can't seem to make it work. I have Microsoft Office XP
and whatever version of Excel is in that. Thanks in
advance for the help or diretion for help.

 

[Mark E. Philpot]

Bill
I think a macro is required.


Insert a column to the right(or left) of intended column
insertion point is b1
The syntax is not right but you will get the idea


sub ProperItUp()
b1.select
b1.formula=proper(a1)

selection.copy
selection.paste pastespecial, values only
copypaste=false
end

b1.column.delete

mark
http://au.geocities.com/excelmarksway

 

[David McRitchie]

Hi Bill,
See Proper, and other Text changes -- Use of SpecialCells
http://www.mvps.org/dmcritchie/excel/proper.htm
for a macro, you don't want to use a formula for this,.

Using the PROPER Worksheet Function would involve lots of extra work
and with a macro you can take care of some lastnames that have
different capitalizations than simply using the PROPER functions
by itself..

Instructions to install and use a macro on my
http://www.mvps.org/dmcritchie/excel/getstarted.htm