While working in an Excel Worksheet, you will come across scenarios where the last name is not separated from the first name by a comma, and doing that manually could be a daunting task. Good thing that this tutorial teaches you how to add comma in Excel between names using SUBSTITUTE function.<\/p>\n
In this tutorial on how to insert comma between words in excel, you will learn:<\/p>\n
SUBSTITUTE function is a type of TEXT function and is used to search and replace text strin<\/a>gs<\/strong> in Excel. It is a very useful function if you wish to replace an old text with new text.<\/p>\n Let’s jump right in and start exploring the features of this function.<\/p>\n What does it do?<\/strong><\/em><\/p>\n It\u00a0replaces specific text in a text string i.e. Substitutes new text for old text in a text string.<\/p>\n Formula breakdown:<\/strong><\/em><\/p>\n =SUBSTITUTE(text<\/span>, old_text<\/span>, new_text<\/span>, [instance_num]<\/span>)<\/p>\n What it means:<\/strong><\/em><\/p>\n SUBSTITUTE function has four arguments<\/strong> – text, old_text, new_text and instamce_num. The first 3 arguments are required and the fourth one is optional.<\/p>\n Let’s work with an example to know how to use SUBSTITUTE function and how to add a comma in excel between names using this function.<\/p>\n I can recall the countless times when I was given a list of names from the HR department and the last\u00a0name was not separated from the first name by a comma.<\/p>\n It drove me nuts!!!<\/p>\n I had to manually edit the names one by one, so that it would look like <last name>, <first name><\/strong><\/em>.<\/p>\n Turns out, the SUBSTITUTE\u00a0<\/b>formula in Excel would have done this task very easily!<\/p>\n In our example below, we have a list of names. \u00a0We want to replace the space with a comma followed by space. \u00a0The SUBSTITUTE<\/strong> formula is able to do this for us!<\/p>\n I explain how you can do this and please go this tutorial on how to add comma in Excel between names:<\/p>\n<\/a>Introduction to SUBSTITUTE function<\/h3>\n
\n
\n<\/a>Add comma in excel between names using SUBSTITUTE function<\/h3>\n