How do you flip first name and last name in excel?



How do you flip first name and last name in excel?..

Answer / Mohd Irfan

"To flip first name and last name in Excel, follow these steps:
1. Enter the full names (last name followed by a space and then first name) in a single column.
2. Select the entire column.
3. Click on Text to Columns (in the Data tab).
4. Choose Delimited and next.
5. Check Space, click Finish.
6. In the Text Box that appears, select last name, then click Move All.
7. Click Finish."

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

What is a conditional formula in excel?

1 Answers  


How can we convert excel to word?

1 Answers  


What is cell in excel sheet?

1 Answers  


What is form control in excel?

1 Answers  


How to create an editable excel spreadsheet?

1 Answers  


Can you do a lookup in excel?

1 Answers  


How many sheets can you have in excel?

1 Answers  


What are some best practices when creating complex models in excel?

1 Answers  


What is f4 in excel?

1 Answers  


What is full form of ref?

1 Answers  


How do I merge rows in sheets?

1 Answers  


What is the importance of ms excel?

1 Answers  


Categories