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
Comments