Note: - We can add any text, symbol and values in CONCATENATE formula. To create the Email ID for all users, copy the same formula by pressing the key Ctrl+C and paste into the range C3:C5 by pressing the key Ctrl+V.The function will create the email address.In column D, we want to return the Full Email Address. Column A contains the first name, column B contains Last Name, and column C contains Domain i.e. Let’s take an example to understand how we can create the Email address. In this article, we will learn how to create an Email address using the Concatenate Function in Microsoft Excel.ĬONCATENATE function is used for joining the several text string into one text string.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |