How would you convert a string to uppercase in MS Excel ?

MS Excel

• Aakanksha
• 30 Jun 2018
• 5 Answers

answer

Answer

×

• • LV
    Leela
  • 30 Jun 2018

  enter=UPPER(A1)

  • 0 Comments

  0

  

  View all vote's

  Mark

  Modal content

  ×

  • All-Votes

  • No Vote

  • No Up Vote

  • No Down Vote

  Close

  ×

  ---

• • MS
    Milan
  • 08 Jun 2018

  =toupper()method

  • 0 Comments

  0

  

  View all vote's

  Mark

  Modal content

  ×

  • All-Votes

  • No Vote

  • No Up Vote

  • No Down Vote

  Close

  ×

  ---

• • DN
    Dandu
  • 23 Mar 2017

  Please use =upper(enter the cell address which you have the small letter) then drag to the next cell in horizontal and verical. text will show you in upper case.
   

  • 0 Comments

  0

  

  View all vote's

  Mark

  Modal content

  ×

  • All-Votes

  • No Vote

  • No Up Vote

  • No Down Vote

  Close

  ×

  ---

• • as
    amit
  • 15 May 2015

  MS Excel has certain built-in functions to perform this change :-
  UPPER - Converts all lowercase letters in a text string to uppercase.
  
  PROPER - Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters.

  Read More

  • 0 Comments

  0

  

  View all vote's

  Mark

  Modal content

  ×

  • All-Votes

  • No Vote

  • No Up Vote

  • No Down Vote

  Close

  ×

  ---