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, ” “, G2)
” ” – 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