lundi 11 mai 2015

Change All Text to Capitals in Excel

Change all text to capitals in excel (excel 2003 2007 2010 2013)

If you need to apply uppercase change for some columns or cells:

Use the UPPER function to convert all letters in a text string to uppercase.

  Change all text to capitals in excel 




 WATCH THE TUTORIAL
(Upper Function - Convert text to upper case in Microsoft Excel 2013)

If you need to apply uppercase change for all text in excel sheet:

Copy the text you need to apply changes
Change all text to capitals in excel



Paste the text in Word Office 

Change all text to capitals in excel


  Select the complete text (CTRL + A) 
Change all text to capitals in excel



  Convert the text to uppercase with shortcut (CTRL + Shift + A) 
Change all text to capitals in excel


  Copy Converted text & Do "paste special" in excel
Change all text to capitals in excel


  Check or Choose "text"
Change all text to capitals in excel

                                 
Change all text to capitals in excel