| Channel | Publish Date | Thumbnail & View Count | Actions |
|---|---|---|---|
 | Publish Date not found |  0 Views |

Description for changing text case in excel
To change the case of text in an Excel spreadsheet, you can use the UPPER, LOWER, or PROPER functions.
Here’s an example of how to use each of these functions:
To convert a cell’s text to all upper case, use the following formula: =UPPER(cell)
To convert a cell’s text to all lower case, use the following formula: =LOWER(cell)
To convert a cell’s text to proper case (first letter in each word is capitalized), use the following formula: =PROPER(cell)
For example, if you wanted to convert the text in cell A1 to all upper case, you would use the formula =UPPER(A1) in another cell.
You can also use the /”Text to Columns/” feature to separate a cell’s contents into multiple cells based on a delimiter, such as a space or a comma. You can then use the PROPER function to convert each cell’s text to proper case.
Finally, you can use the /”Format Cells/” feature to change the case of selected text. To do this, select the cells you want to modify, right-click on the selection, and choose /”Format Cells/” from the context menu. In the /”Format Cells/” window, go to the /”Font/” tab and choose the case you want to apply (e.g. /”Upper Case/
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
