How to Add "Mr." and "Ms." in Excel Sheet | Advanced Excel Formula.
Description:
In this tutorial, you’ll learn how to automatically add "Mr." or "Ms." before names in Excel using a simple formula. This is useful for creating professional documents, mail merges, certificates, or employee records.
✔
Formula Example:
```excel
=IF(B2="M","Mr. ","Ms.") & A2
```
Here, `A2` contains the name and `B2` contains gender (M/F).
In this video:
1. How to use `IF` and `&` to join text
2. Apply logic to add Mr. or Ms. based on gender
3. Auto-fill the formula for multiple rows
4. Best practices for formatting names professionally
This advanced Excel trick will save you time and make your data look clean and formal. Perfect for HR sheets, invites, or admin work. Don’t forget to like, comment, and subscribe for more helpful tips!
#ExcelTips #ExcelFormulas #AdvanceExcel #IFfunction #TextFormula #ExcelUrdu