How to Automatically Add Mr or Mrs Before Names in Excel
Working with large lists of names in Excel can sometimes require adding titles such as Mr, Mrs, or Dr. Manually typing these titles for hundreds of rows can be slow and repetitive.
Fortunately, Excel provides a faster method using custom formatting. With just a few clicks, you can automatically add titles before every name in a column.
Watch the Tutorial
Table of Contents
- Why Add Prefix Titles in Excel
- Using Custom Formatting
- Step-by-Step Method
- Benefits of Excel Formatting Tricks
Why Add Prefix Titles in Excel
Many professional documents require names to include titles like Mr, Mrs, or Ms. For example:
- Customer databases
- Email lists
- Business reports
- Client contact sheets
Manually editing each cell can take time. Excel’s custom formatting allows you to apply these titles instantly.
Step-by-Step Method
- Select the entire column containing names.
- Press Ctrl + 1 to open the Format Cells menu.
- Choose the Custom category.
- Enter a custom format like: "Mr. "@
- Click OK.
Excel will automatically display "Mr." before every name in the selected column.
Adding Other Titles
You can use the same method for different prefixes:
- "Mrs. "@
- "Dr. "@
- "Prof. "@
This technique works instantly without changing the original data.
Why This Excel Trick Is Useful
Custom formatting is a powerful Excel feature that saves time and improves data presentation. Instead of editing hundreds of cells manually, one formatting rule can update the entire dataset.
Learning small Excel shortcuts like this can dramatically improve productivity for analysts, administrators, and office professionals.
Follow Discover Talent for more Excel tips, AI tools, and data analytics tutorials.
Comments