Duration: 2:24

0 views

0

Here's how to Change Lowercase to Uppercase in Microsoft Excel.

Here are a few ways to change lowercase text to uppercase in Excel:

- Use the UPPER formula:

=UPPER(A1)

Where A1 is the cell with the lowercase text. This will convert the text to all uppercase.

- Use Find & Replace:

1. Select the cells you want to change case.
2. Go to the Home tab and click Find & Select - Replace.
3. In the Find what field, enter a lowercase letter e.g. "a".
4. In the Replace with field, enter the same letter but uppercase e.g. "A".
5. Click Replace All.

- Use the PROPER formula:

=PROPER(A1)

This capitalizes the first letter of each word while lowercasing all other letters.

- Use Text to Columns:

1. Select the cells with text to change case.
2. Go to Data tab and click Text to Columns.
3. Choose Delimited, deselect all delimiters and click Next.
4. Select Uppercase on the next screen and click Finish.

- Use Conditional Formatting to highlight cells with lowercase text. Then edit each cell manually.

So in summary, the UPPER, PROPER, Find & Replace, and Text to Columns options are the fastest ways to convert text case in Excel.