Upper/Lower Case Question 2

[jhruby]

I have an Excel 2002 spreadsheet that has a column of names that are upper case (JEFF JONES). Is there a way to have Excel change these to Upper-Lower case (Jeff Jones) so they are correct for variable data mailing?

 

[SkipVought]

Hi,

You can use =PROPER(ref)

Create a new column for this formula
Copy it down
copy the entire formula range
Paste Special-Values in the Name range

Be sure to save your workbook before attempting this.



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[jhruby]

That works sooo slick! Thanks a million!

 

[PWD]

I knew I'd seen something for this. Microsoft Knowledge Base Article - 291323

Macro to Change All Text in a Cell Range to Initial Capital Letters
Sub Proper_Case()
' Loop to cycle through each cell in the specified range.
For Each x In Range("C1:C5&quot
' There is not a Proper function in Visual Basic for Applications.
' So, you must use the worksheet function in the following form:
x.Value = Application.Proper(x.Value)
Next
End Sub

Anyway it's another way.

Des.

 

[SkipVought]

PWD,

If jhruby had posted this question in the VBA Forum, I'd have replied with a VBA answer. In the Office Forum, we try to use non-programming solutions.



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com