How To Merge First and Last Name In Excel

In this tutorial we will learn how to merge first and last name in Excel by using the Text join function. =TEXTJOIN(delimiter, ignore_empty, text1, [text2, …]) This function allows us to join different text strings in one textbox.  Delimiter : The delimiter is a string, possibly empty, or a reference to a valid string. If … Read more

You can watch a video tutorial here.