In this article you will learn how to convert any string into Uppercase, Lowercase and Proper case in Excel. You will also learn data validation for only Uppercase entry or in any text case and automatic Uppercase in Excel. You will also see Excel VBA UDF for converting specific word or substring in a string ... Read more