Now in cell C2, I input this formula: =CONCATENATE(A2," ",B2) We insert a new column after the Last Name and name it as Full Name. 1) Merging two cells using CONCATENATE () function We want to merge two or more cells without losing data. Cell A2 and B2 are merged into one cell A2 and it is only showing the value, Rickey. If you click on the OK button, then cell A2’s value (upper-left) will be intact and cell B2’s value will be discarded. So, I select cells A2 and B2 and click on the drop-down part of the Merge & Center command and choose Merge & Center command from the list.Įxcel will show you a message like the following one. Say, I want to combine ‘First Name’ and ‘Last Name’ parts and want to make ‘Full Name’. In the image below, you are seeing some First names, last names, and some addresses (Address 1, Address 2, and Address 3). 4) Using Text Editor Why cannot you use Merge & Center command in this case?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |