To combine first and last names in Excel, you can use the CONCATENATE or &a

How do I combine first and last names in excel?

Question Posted / Sandeep Kumar Bharti

1 Answers
788 Views
I also Faced
E-Mail Answers

Answer Posted / Sandeep Kumar Bharti

To combine first and last names in Excel, you can use the CONCATENATE or & operator. If your data is in columns A (first names) and B (last names), you can combine them with '=CONCATENATE(A1, " ", B1)' or '=A1&" "&B1'.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How much is excel for ipad?

714

What is wrap text in excel?

721

Image result for how do I compare two columns in excel

668

Which is latest version of excel?

722

What is left formula in excel?

684

Why can't I see the tabs on my excel spreadsheet?

724