Please tell me how I can split combined data into separate columns in an excel spreadsheet. For example I have a spreadsheet that contains the city and state (i.e.kennett square, pa) in the same column and I would like to have them in two separate columns?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More MS Excel Microsoft Interview Questions

Why do excel files get corrupted?

0 Answers  


How do I merge two excel ids?

0 Answers  


What are the benefits of spreadsheet?

0 Answers  


What are the advantages of what if analysis?

0 Answers  


Difference between count, counta, countif and countblank in ms-excel.

0 Answers  


How do I add and delete columns and rows in excel spreadsheet?

0 Answers  


How do you close a worksheet in excel?

0 Answers  


How do I find the #ref error in excel?

0 Answers  


How do I automatically convert numbers to words in excel?

0 Answers  


How do I change the default font in excel 2016?

0 Answers  


What are the 3 types of cell references in excel?

0 Answers  


How do I see all data in excel?

0 Answers  


Categories