As Seen on TechCrunch: Finofo Raises \$1.65M CAD!

## How to Capitalize Text in Excel: A Step-by-Step Guide

Changing the capitalization of text in Excel can be done using various functions. Here's a step-by-step guide on how to achieve this:

#### Changing the Capitalization of a Single Cell

1. UPPER Function:

• To change the content of a single cell (e.g., A1) to uppercase, enter the formula =UPPER(A1) in another cell (e.g., B1).

2. LOWER Function:

• To change the content of a single cell (e.g., A1) to lowercase, enter the formula =LOWER(A1) in another cell (e.g., B1).

3. PROPER Function:

• To change the content of a single cell (e.g., A1) to proper case, enter the formula =PROPER(A1) in another cell (e.g., B1).

#### Changing the Capitalization of Multiple Cells

1. UPPER, LOWER, or PROPER Functions with Range:

• Use the functions with a range reference to change the capitalization of multiple cells.
• Example: =UPPER(A1:A10), =LOWER(A1:A10), =PROPER(A1:A10).

#### Changing the Capitalization of a Column, Row, or Range

1. Select the Target Range:

• Select the column, row, or range of cells you want to modify.

2. Use the Appropriate Function:

• For a column, use formulas like =UPPER(A1) in cell B1 and drag it down.
• For a row, use formulas like =UPPER(A1) in cell B1 and drag it across.
• For a range, use formulas like =UPPER(A1:B10) in cell C1.

#### Changing the Capitalization of a Worksheet or Workbook

1. Apply Functions to Entire Worksheet or Workbook:

• For an entire worksheet, use formulas like =UPPER(A1:A1048576) in cell B1 (adjust the range as needed).
• For an entire workbook, apply the formulas to the respective cells in each sheet.

#### Note:

• UPPER Function: Converts text to uppercase.
• LOWER Function: Converts text to lowercase.
• PROPER Function: Converts the first letter of each word to uppercase.

#### Example:

• If cell A1 contains "example TEXT," using =UPPER(A1) in cell B1 will result in "EXAMPLE TEXT."
• Using =LOWER(A1) will result in "example text."
• Using =PROPER(A1) will result in "Example Text."

These functions provide flexibility in changing the capitalization based on your specific needs, whether for a single cell, a range, or an entire worksheet/workbook. Adjust the formulas according to the location and extent of the data you want to modify.