CHANGING Case in Excel or Access - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Microsoft Windows and Software
Closed Thread
Thread Tools Display Modes
Old 04-21-2005, 09:02 AM   #1 (permalink)
Content Team
Join Date: Mar 2005
Posts: 83
Default CHANGING Case in Excel or Access

I have a database that is all capital letters and hate to use that for my letters. Can anyone tell me how to change the case from ALL CAPS to First Letter Caps to the entire list?

dennykyser is offline  
Old 04-21-2005, 11:55 AM   #2 (permalink)
Master Techie
Join Date: Oct 2003
Posts: 2,258

This is a fix for word, but if you apply the same logic you might beable to do it for the data files.
and here is one for excel.

Good luck

Inaris is offline  
Old 04-21-2005, 04:09 PM   #3 (permalink)
True Techie
Join Date: Feb 2005
Posts: 151

Using the MrExcel link Inaris has provided you, you can copy your Access Databse info into excel, change it there and copy it back.
Be not afraid of growing slowly, be afraid only of standing still - Knowledge will get you somewhere, stupidity will get you nowhere
Catbert is offline  
Old 04-21-2005, 04:40 PM   #4 (permalink)
Content Team
Join Date: Mar 2005
Posts: 83

Thanks for the help I will try that tonight.
dennykyser is offline  
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Our Communities

Our communities encompass many different hobbies and interests, but each one is built on friendly, intelligent membership.

» More about our Communities

Automotive Communities

Our Automotive communities encompass many different makes and models. From U.S. domestics to European Saloons.

» More about our Automotive Communities

Marine Communities

Our Marine websites focus on Cruising and Sailing Vessels, including forums and the largest cruising Wiki project on the web today.

» More about our Marine Communities

Copyright 2002-2015 Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 12:19 AM.

Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2016, vBulletin Solutions, Inc.