It then moved to the MS-DOS operating system in 1982, by which time the name WordPerfect was in use, and several greatly updated versions quickly followed. The authors retained the rights to the program, forming the Utah-based Satellite Software International (SSI) in 1979 to sell it the program first came to market under the name SSI*WP in March 1980. It was originally developed under contract at Brigham Young University for use on a Data General minicomputer in the late 1970s. At the height of its popularity in the 1980s and early 1990s, it was the dominant player in the word processor market, displacing the prior market leader WordStar. The quickest way to do this is by selecting cell B2, and then double-clicking the small black square that appears in the lower-right corner of the cell.WordPerfect ( WP) is a word processing application, now owned by Corel, with a long history on multiple personal computer platforms. Now, fill down the formula in the new column. Use =UPPER(A2) in cases where you need to convert text to uppercase, replacing A2 with the appropriate cell reference. To convert the text to lowercase, type =LOWER(A2) instead.

This formula converts the name in cell A2 from uppercase to proper case.

In cell B2, type =PROPER(A2), then press Enter. In this case, we’ve added a new column (B) to the right of the Customer Name column. In the example below, the PROPER function is used to convert the uppercase names in column A to proper case, which capitalizes only the first letter in each name.įirst, insert a temporary column next to the column that contains the text you want to convert. Functions are just built-in formulas that are designed to accomplish specific tasks-in this case, converting text case. However, you can use the UPPER, LOWER, or PROPER functions to automatically change the case of existing text to uppercase, lowercase, or proper case. Unlike Microsoft Word, Microsoft Excel doesn't have a Change Case button for changing capitalization. Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel for iPad Excel for iPhone Excel for Android tablets Excel 2010 Excel 2007 Excel for Mac 2011 Excel for Android phones Excel Mobile More.

Ms word 2011 for mac change case