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

General Formula:

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

=UPPER(LEFT(A1))&MID(A1,2,LEN(A1))

Syntax Explanations:

  • UPPER – This function helps to convert all letters in the specified string to uppercase. Read more on the UPPER Function.
  • LEFT – The LEFT Function 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 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.
  • 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.
  • Select any cell and apply the above-given formula.
  • Finally, press ENTER to get the result out.

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!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **

Read Ahead:

25