Microsoft office 2011 (mac)

Joined
Jun 26, 2010
Messages
11
Reaction score
0
Points
1
Hi Guys

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
 
Joined
Apr 19, 2011
Messages
35
Reaction score
3
Points
8
Location
Virginia
Your Mac's Specs
Early 2011 MBP i5 2.3GHz 13" 8Gb Ram 120Gb SSD
Use the =Upper(cellreference) command.

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.
 

Shop Amazon


Shop for your Apple, Mac, iPhone and other computer products on Amazon.
We are a participant in the Amazon Services LLC Associates Program, an affiliate program designed to provide a means for us to earn fees by linking to Amazon and affiliated sites.
Top