Excel Formulas to Capitalize the First Letter of a Text String!!
Tags: excelformula, excelformulas
Published: 2021-06-02 03:50:41

---
title: Excel Formulas to Capitalize the First Letter of a Text String!!
published: true
date: 2021-06-01 06:53:49 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-capitalize-the-first-letter-of-a-text-string/
---

Have you ever tried to **capitalize the first letter of a text string in Excel**? Here, I introduce you to some formulas to solve this problem. Let’s see them below!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Capitalize the first letter](https://geekexcel.com/wp-content/uploads/2021/06/Capitalize-the-first-letter.png)](https://geekexcel.com/excel-formulas-to-capitalize-the-first-letter-of-a-text-string/capitalize-the-first-letter/#main)<figcaption id="caption-attachment-45913">Capitalize the first letter</figcaption>

## General Formula:

- Use the below formula to capitalize the first letter in a word or string.

**=[UPPER](https://geekexcel.com/how-to-use-upper-function-in-microsoft-excel-365/)([LEFT](https://geekexcel.com/how-to-use-left-function-in-microsoft-excel-365/)(A1))&[MID](https://geekexcel.com/how-to-use-mid-function-in-microsoft-excel-365/)(A1,2,[LEN](https://geekexcel.com/how-to-use-len-function-in-microsoft-excel-365/)(A1))**

## Syntax Explanations:

- **UPPER** – This function helps to convert all letters in the specified string to uppercase. Read more on the **[UPPER Function](https://geekexcel.com/how-to-use-upper-function-in-microsoft-excel-365/)**.
- **LEFT** – The **[LEFT Function](https://geekexcel.com/how-to-use-left-function-in-microsoft-excel-365/)** helps to extract the first character (starting from the left side) or characters from the given string based on the number you specified
- **MID** – In Excel, the **[MID function](https://geekexcel.com/how-to-use-mid-function-in-microsoft-excel-365/)** extracts the number (starting from the left side) or characters from the given string
- **LEN** – It is used to find the length of the text string. Read more on the [**LEN Function**](https://geekexcel.com/how-to-use-len-function-in-microsoft-excel-365/).
- **A1** – It represents the input text strings.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Practical Example:

Refer to the below example image.

- First, we will enter the input text values in **Column B**.
- Here, we are going to capitalize the first letter of the text string.

![Input Range](https://geekexcel.com/wp-content/uploads/2021/06/Input-Range.png)<figcaption id="caption-attachment-45911">Input Range</figcaption>

- Select any cell and apply the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/06/Enter-the-formula.png)<figcaption id="caption-attachment-45914">Enter the formula</figcaption>

- Finally, press  **ENTER**  to get the result out.

![Result](https://geekexcel.com/wp-content/uploads/2021/06/Result.png)<figcaption id="caption-attachment-45912">Result</figcaption>

## Wrap-Up:

So yeah guys, this is how we can **capitalize the first letter of a word in Excel**. Hope you like it. If you have any doubt regarding this article or have any other **questions** related to Excel, let me know in the **comments** section below.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Ahead:

- **[How to Find the Last Column of Data in Excel Office 365?](https://geekexcel.com/how-to-find-the-last-column-of-data-in-excel-office-365/)**
- **[Excel Formulas to Convert Text into Date Format ~ A Complete Tutorial!!](https://geekexcel.com/excel-formulas-to-convert-text-into-date-format/)**
- **[Excel Formulas to Add a Line Break Based on the Current OS ~ Quickly!!](https://geekexcel.com/excel-formulas-to-add-a-line-break-based-on-the-current-os-quickly/)**
- **[How to Wrap Text Manually in Excel Office 365? {3 Ways}](https://geekexcel.com/how-to-wrap-text-manually-in-excel-office-365-3-ways/)**