Removing Salutation from Name

This post will guide you how to remove salutations from names in the range of cells in excel. How do I remove the salutation from the names cells with formula in Excel. For example, if you have name salutations and you want to remove those salutations from name strings in excel, how to achieve it. How to split salutation and only names string into separate columns with excel formula.

Removing Salutation from Name


To remove salutation from names string in excel, you can create a formula based on the RIGHT function, the LEN function and the FIND function.

Assuming that you have a name list in the range of cell B1:B4, and you want to remove all salutations from those cells, you can write down this formula to achieve the result.

=RIGTH(B1,LEN(B1)-FIND("",B1))

You just need to type this formula into a blank cell, then press enter key in your keyboard. Then you still need to drag the AutoFill Handler over other cells to apply this formula to remove salutations.

Let’s see the last result:

removing salutation from name1

Split salutations and name strings into different columns

If you want to split salutations and name string into different columns, you can extract the salutation string firstly, then extract the rest name string again. You need to create the first formula based on the LEFT function and FIND function to extract salutation string. And you still need to use another formula based on the MID function and the FIND function to get the names strings from those cells. Like these two formulas:

=LEFT(B1,FIND(" ",B1)-1)

=MID(B1,FIND(" ",B1)+1,100)

Type the first formula into a blank cell to get the salutation strings, then press enter key and drag the AutoFill Handler over other cells.

removing salutation from name2

Type the second formula into a blank cell in a new column to get the name strings, then press enter key and then drag the AutoFill Handler over other cells to apply this formula to extract names.

removing salutation from name3

Related Functions


  • Excel LEFT function
    The Excel LEFT function returns a substring (a specified number of the characters) from a text string, starting from the leftmost character.The LEFT function is a build-in function in Microsoft Excel and it is categorized as a Text Function.The syntax of the LEFT function is as below:= LEFT(text,[num_chars])…t)…
  • Excel FIND function
    The Excel FIND function returns the position of the first text string (sub string) within another text string.The syntax of the FIND function is as below:= FIND(find_text, within_text,[start_num])…
  • Excel RIGHT function
    The Excel RIGHT function returns a substring (a specified number of the characters) from a text string, starting from the rightmost character.The syntax of the RIGHT function is as below:= RIGHT (text,[num_chars])…
  • Excel MID function
    The Excel MID function returns a substring from a text string at the position that you specify.The syntax of the MID function is as below:= MID (text, start_num, num_chars)…
  • Excel LEN function
    The Excel LEN function returns the length of a text string (the number of characters in a text string).The syntax of the LEN function is as below:= LEN(text)…

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar