Revision as of 13:46, 25 March 2019 by Devika (talk | contribs) (→‎Examples)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
MIXEDCASE(String, Concat)

  • is the text which we want change in to a uppercase.


  • This function displays first letter of every word entered to upper case letter.
  • Upper case letters are the alphabetical capital letters and Lower case are the alphabetical small letters.
  • Capital letters:ABCDEF…..,Small letters:abcdef….
  • Text should be entered in double quotes("").


  • MIXEDCASE("total marks")=Total Marks
  • MIXEDCASE("United Kingdom")=United Kingdom
  • MIXEDCASE("Hello, how are you doing?") = Hello, How Are You Doing?
  • MIXEDCASE("address:#83,salai street") = Address:#83, Salai Street
  • MIXEDCASE(cool)=Null

Related Videos

Mixed Case

See Also


Letter case