How to combine First name and last name in excel

Use below code for combining first name and last name.

Code is = A1 & B1

For adding space in between name write below

A1&” ” &B1

 

Leave a Reply

Your email address will not be published. Required fields are marked *