Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-29-2005, 08:35 AM
jd jd is offline
Novice
Upper to lower case
 
Join Date: Nov 2005
Posts: 2
jd
Default Upper to lower case

Hello



I would like to know if can change cells data from all upper case letters (example: “CHARLES SIMON BLACKMAN”) to a “Charles Simon Blackman” globally. if so can you please explain
Reply With Quote
  #2  
Old 04-28-2006, 07:40 AM
aceensor aceensor is offline
Novice
 
Join Date: Apr 2006
Posts: 5
aceensor
Default

insert a column to the right of the column you're wanting to change. In the first cell of the new column, enter this:

=PROPER(cell) (cell = the first cell of the column to change)

Copy the formula down, and it will change the first letter of each word to upper case, and the rest to lower.

Hide the original column and you should be good to go!
Reply With Quote
Reply

Thread Tools
Display Modes


Other Forums: Access Forums

All times are GMT -7. The time now is 02:39 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft