Wednesday, January 23, 2019

mR. & mRs.



When we have completed our data and submit that data to our authority and they say to add salutation MR. or MRS.  In front of the name or Kumar , Singh and the end of the name. A blunder take place because you have completed the data . You don’t need to make that data again . By applying a simple formula you can resolve this .

  • There are some names in which we add salutation MR. and MRS.



  • Now we apply the formula = “MR “ &Select Name . then press enter . And for female write =”MRS. “&Select Name . then press enter . After MR. / MRS. You can see there is a space this is because to separate the salutation from name.

  • No need to apply formula again and again just simply drag it and paste in the desired cell . You can see the formula in the formula bar



  • As salutation MR. and MRS. You can add KUMAR and SINGH at the end of the name as suffix .
  • By applying =Select Name “ Kumar “ . Then press ENTER 







at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

FrEeZe PaNe

In a company or a school we have a number of students and employees and we maintain the data of all of them but sub times a hindrance ca...

  • SpLiT nAmE
    This formula is related to the separation of the first name and the last name in different cells. We generally write the name with its s...
  • MuLtIpLy
    The next formula is basically for calculating total amount of per unit price of the product  or salary of the employees per day etc  ...
  • mR. & mRs.
    When we have completed our data and submit that data to our authority and they say to add salutation MR. or MRS.   In front of the name...