Re: automatically changing text case

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Bob Flanagan (noreply_at_noreply.net)
Date: 03/25/04 

Date: Wed, 24 Mar 2004 19:16:14 -0500

You can use the function Proper(cell ref) to get part way there. It works
great on names like john q doe. However, on names like ron mcdonald, which
comes out Ron Mcdonald, not Ron McDonald. You can then do a series of
global changes to fix these.

If you have to do the task often, you can automate it with the Data Cleaner
available from my site. It allows you to store such global change commands
and use them over and over.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"SusanC" <anonymous@discussions.microsoft.com> wrote in message
news:7CB0A4C9-B2D6-4E89-A08B-1EA1B808C0A8@microsoft.com...
> I am merging several different excel spreadsheets and some of the names
are in all uppercase and some are first initial of name in uppercase and the
rest in lowercase. Is there an easy way (as in Word) to highlight all the
names in uppercase and automatically change them to first letter uppercase,
rest lower case???

Quantcast