 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / September 2008Column of Names upper case: I wanted upper lower
Version: 2004 Operating System: Mac OS X 10.4 (Tiger) Processor: Power PC My intern made a columns of first names in upper case. I wanted upper lower? Anything I can do? thanks kevs1 - Use the PROPER worksheet function in an adjacent helper column. - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel > Version: 2004 > Operating System: Mac OS X 10.4 (Tiger) > Processor: Power PC > > My intern made a columns of first names in upper case. I wanted upper > lower? Anything I can do? thanks Sorry Mike, did not understand of word you just said. Hi Kevs - What Mike suggested is this: Let's assume that the names start in cell A5; In another column enter the function: =PROPER(A5) Copy the formula down as far as necessary Select & Copy the cells containing the formulas (now displaying the names in proper case) Go to cell A5 & use Edit> Paste Special - Values to replace the upper case names with the proper case version. HTH |:>) Bob Jones [MVP] Office:Mac On 9/7/08 7:48 PM, in article 59b58ec5.1@webcrossing.caR9absDaxw, > Sorry Mike, did not understand of word you just said. Excellent Bob, thanks. Then to clear out any remnants of forumulas in that column I used that might haunt me later, I just select that columns and do Edit, clear , All? thanks Correct! Regards |:>) Bob Jones [MVP] Office:Mac On 9/8/08 2:01 AM, in article 59b58ec5.3@webcrossing.caR9absDaxw, > Excellent Bob, thanks. > Then to clear out any remnants of forumulas in that column I used that might > haunt me later, I just select that columns and do Edit, clear , All? thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.