How to format text in Microsoft Excel using UPPER, BOTTOM and CORRECT functions: - Forget about deleting all the text just because you forgot to enter it in the correct format. Now you can write the text the way you feel comfortable and then format the text with three simple functions; UPPER, BOTTOM and FIT functions. Dive into the article to learn all about this simple trick.
1 STEP
- Open the Stand Out sheet which has plain text. Say you want it to be Correctly formatted. That is, you want the first letter of each word to be uppercase and the rest lowercase.
2 STEP
- For this, click on the cell adjacent to the highest cell in the raw column. That is, if the unqualified text starts in cell A1, you need to click and select cell B1. Now in the formula bar, type = ELIGIBLE (A1). When done, hit the Enter key.
- Note: Cells A1 and B1 are provided as examples. You can choose any cell as long as it meets the conditions of being adjacent to each other and in the same row. Otherwise, you won't be able to apply the formula rule to the rest of the column.
PHASE 3
- Now click on the little one square box in the lower right corner of the new cell. This will apply the formula rule to the entire column.
PHASE 4
- Here it is! You have successfully applied the formula rule to the entire column. So, let's remove the first column that isn't formatted. For this, copy and paste will not be enough, as this will give you formula error. Follow the steps below to fix this problem.
PHASE 5
- Copy the contents of the second column by right clicking and choosing copy. Or you can use the key combination of CTRL + CLOSE.
PHASE 6
- As below, choose the entire first row. You can do this by clicking on the cell header, e.g. UN I our case. Now right click and choose Special glue. Some options in Special glue, Choose Paste the values. You can click on the first option in the file Paste the values Tickets. That is. Please refer to the screenshot below for reference.
PHASE 7
- Now you can see that the values in the second column have been successfully cloned into the first.
PHASE 8
- At this stage, you can easily delete the second column by clicking its cell header, second and hit To remove key.
PHASE 9
- You can also try capitalizing all text. For this, the function used is HIGHER function. As before, click in the adjacent cell and in the formula bar, type = TOP (A1).
PHASE 10
- Again, click small square to apply the formula to the entire column.
PHASE 11
- The next is to convert all the text to lowercase letters. For this, the function used is INFERIOR function. As before, click in the adjacent cell and in the formula bar, type = LOWER (A1).
PHASE 12
- Click on small square to apply the formula to the entire column. Yes, we're done!
Hope you found the article useful. Please leave comments if you have any questions. We will be happy to help you. Stay tuned for more tips, tricks and tips.
