How to combine first name & last name in Microsoft excel & Google sheets ?


In today's article, we will learn how to add first name and last name in Microsoft Excel or Google Sheets. It is very simple and at the same time very useful. The topic of today's post is "How to combine first name & last name in Microsoft excel & Google sheets?"

So without delay we come to our points, and first of all we will learn how to add First Name and Last Name in Microsoft Excel.

To combine First Name and Last Name in Microsoft Excel, we use a function or formula, which we call "concatenate".

How to put formula in Microsoft Excel ?

First of all open Excel. Now set this formula in the cell where you want to create first name and last name. The name of the formula or function is concatenate (constant).

How to set formula?

=concatenate,(F2 , " " F3)

 " " - there is a space between it. The amount of space left here, the same space will remain between the first name and the last name.

For rest of the result use control + D

Microsoft Excel

Microsoft Excel
Microsoft Excel

How to put formula in Google Sheets ?

Here this formula becomes even easier

Open Google Sheets 

First open Google Sheets. Where you want to put the output or formula, type =concatenate, first name) " ", last name)

press enter button.


Google Sheets

Google Sheets

I hope , you liked this article. thanks for reading.





Post a Comment

أحدث أقدم

INNER POST ADS