Excel Formulas to Put the Names into Proper Cases ~ Quickly!!
Tags: excelformula, excelformulas
Published: 2021-07-06 09:31:35

---
title: Excel Formulas to Put the Names into Proper Cases ~ Quickly!!
published: true
date: 2021-07-01 14:17:47 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-modify-the-names-into-proper-cases/
---

Excel allows us to put names in proper cases using the **[PROPER function](https://geekexcel.com/use-proper-function-in-microsoft-excel-2013-simple-methods/)**. This step-by-step tutorial will assist all Excel users to **put their names into the proper cases**. Let’s step into this article!! 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)

[![Modify the name into proper case](https://geekexcel.com/wp-content/uploads/2021/07/Modify-the-name-into-proper-case.png)](https://geekexcel.com/excel-formulas-to-modify-the-names-into-proper-cases/modify-the-name-into-proper-case/#main)<figcaption id="caption-attachment-48251">Modify the name into proper case</figcaption>

## Generic Formula:

- Use the below formula to modify names into proper cases in Excel.

**=[PROPER](https://geekexcel.com/use-proper-function-in-microsoft-excel-2013-simple-methods/)(name)**

## Syntax Explanations:

- **PROPER** – In Excel, the **[PROPER function](https://geekexcel.com/use-proper-function-in-microsoft-excel-2013-simple-methods/)** helps to capitalize each word in a given string.
- **Name** – It represents the input names given in unproper cases.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Practical Example:

Refer to the below example image.

- Here we will enter the input names in **Column B**.
- Now we are going to modify these names into the proper cases.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/07/Input-Ranges-3.png)<figcaption id="caption-attachment-48250">Input Ranges</figcaption>

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

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

- Finally, press the ** ENTER**  key, you can get the result as shown below.

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

## Closure:

From this guide, you can get to know the simple formulas to **put the name into a proper case in Excel**. Let me know if you have any **doubts** regarding this article or any other article on this site. We will assist you!!

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:

- **[Excel Formulas to Calculate the Surface Area of a Cylinder ~ Easily!!](https://geekexcel.com/excel-formulas-to-calculate-the-surface-area-of-a-cylinder/)**
- **[Excel Formulas to Join the First and Last Name ~ Simple Tips!!](https://geekexcel.com/excel-formulas-to-join-the-first-and-last-name/)**
- **[Formulas for Finding Largest Value Smaller than a Specified Number!!](https://geekexcel.com/formulas-for-finding-largest-value-smaller-than-a-specified-number/)**
- **[Excel Formulas to Calculate the Surface Area of a Cone ~ Easy Tricks!!](https://geekexcel.com/excel-formulas-to-calculate-the-surface-area-of-a-cone/)**
- **[Excel Formulas to Calculate the Area of a Trapezoid ~ Easy Tricks!!](https://geekexcel.com/excel-formulas-to-calculate-the-area-of-a-trapezoid/)**