How do I combine first and last names in excel?



How do I combine first and last names in excel?..

Answer / 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

More MS Excel Microsoft Interview Questions

How do you compare two items in excel?

1 Answers  


How do you format time in excel?

1 Answers  


How do I merge cells in excel for mac?

1 Answers  


How do you reverse names in excel?

1 Answers  


What does colon mean in excel formula?

1 Answers  


What are the different types of data entries in spreadsheet?

1 Answers  


Some of the functions that we want our macros to accomplish are not possible without first unprotecting the worksheet/workbook with the password?

1 Answers  


What is pivot cache in excel vba?

1 Answers  


How do I add a font to excel 2007?

1 Answers  


How do I compare two excel lists for differences?

1 Answers  


How do I compare two lists in excel for missing data?

1 Answers  


How do I start an excel spreadsheet?

1 Answers  


Categories