| OS X - Apps and Games Discussion of applications and games available for Mac OS X. |
Microsoft office 2011 (mac)
| Post Reply | New Thread | Subscribe |
|
|
Thread Tools |
 Member Since: Jun 26, 2010
Posts: 11
 
|
07-19-2011, 06:59 AM
I currently use MS Office 2011 (Mac). I have a database that has just been sent to me and there is a whole column that is in lower case, and I want it in capitals. Is there a way that I can change it all to capitals without having to do it manually for each entry? Thanks in advance Mark |
| QUOTE Thanks | |
|
Member Since: Apr 19, 2011
Location: Virginia
Posts: 35
Mac Specs: Early 2011 MBP i5 2.3GHz 13" 8Gb Ram 120Gb SSD
|
07-19-2011, 08:48 AM
For instance if cell a1 is abc, enter =Upper(a1) into cell b1. Once you've done this, then copy cell b1 and use paste special/values to cell a1. |
| QUOTE Thanks | |
| Post Reply | New Thread | Subscribe |
| Thread Tools | |
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
|
|
|||||||
Thread |
Thread Starter |
Forum |
Replies |
Last Post |
| Microsoft Office 2011 Installation Disk Keeps Ejecting | Suedesign | Apple Desktops | 6 | 07-25-2011 06:12 PM |
| Updates: Airport Utility, Microsoft Office for Mac 2011 | OneMoreThing... | Apple Rumors and Reports | 0 | 06-14-2011 10:00 PM |
| Office 2011 for Mac requires activation | PKGuy323 | OS X - Apps and Games | 18 | 10-25-2010 06:33 PM |
| Microsoft confirms Office SP2 can't read Win-created files | Colonel Panic | OS X - Apps and Games | 3 | 07-31-2009 03:20 PM |
| Mac Users Get More ISP Choices | schweb | Apple Rumors and Reports | 1 | 03-06-2003 10:57 AM |
