How to Add Mr and Mrs Before Names in Excel (Quick Method)

Mr. Devotor

Learn how to easily type Mr and Mrs before every name in Excel using a simple formula. This tutorial is perfect for beginners, office workers, data entry professionals, teachers, and anyone who works with name lists. We will show how to apply prefix text to names in bulk without typing manually. Just follow the step-by-step guide and save your time.  Formula Used in This Video: ="Mr " & A2 ="Mrs " & A2  If this video helps you, don't forget to Like, Share, and Subscribe!  Hashtags  #excel #exceltips #exceltricks #dataentry #officetips #microsoftoffice #exceltraining #excelformula #howtoexcel #mr #mrs #nameslist

Transcript

00:00if your voice says you have to put mr and mrs before every name in this excel data so if you

00:07have big data and if you do it manually so it will take lot of time and energy so how you can

00:14make it quick and fast first you need to select the all data and then click ctrl shift plus l to

00:25enable the filters and then head to the gender and click on that and only select female and now you

00:34have only female's name in the filter select the all female names and head to the right click and

00:42click format cells and in the customs in where you can see that general you need to remove it

00:54and type double quote and type mrs and double quote space and put the at the rate sign and click ok

01:05and within a few seconds you have done your job and similarly remove the filters and select mail now

01:12and select the mails and now right click and go to the format cells head to the customs and type

01:23double quote mr double quote space at the rate sign click ok and here the magic is done so i hope you

01:34have understand how you can quick and fast to add mr and mrs before every name in excel so if you think

01:40this video is helpful and you have learned something new please support my channel thanks for watching

Category

Transcript

Be the first to comment

Recommended