Excel - Capitals 2

[zacksack]

I have a spreadsheet full of contacts (about 800) and most are all capitals. What I mean is the name looks like this BOB SMITH and I want it to look like this Bob Smith. The question I have is this, is there a quick way to make this change to all 800 entries? or do I have to go back in and manually correct each and every one of them. :-(

Thanks so much

Brad

 

[Dreamboat]

See this for complete instructions:

http://www.vbaexpress.com/kb/e0001.htm

Now, change the one line in the code from this:

UCRng.Value = UCase(UCRng.Value)

to this:

UCRng.Value = StrConv(UCRng.Value, vbProperCase)

Of course, you'll have to fix the McCoys and such manually; usually done very easy with a search..

Anne Troy
Supercharge your Office Applications:

http://www.vbaexpress.com

 

[Tiglet]

Or without VBA use formulae eg. if BOB SMITH is in A1

=PROPER(A1)

Tiglet

Living on Earth is expensive, but it does include a free trip around the sun every year