How to split a single columns' text into multiple columns?
Correct answer: B. Data>>Text to Columns
- A. Data>>Sort & Filter
- B. Data>>Text to Columns
- C. Home>>Fill>>Justify
- D. Home>>Editing>>Justify
Explanation
Excel's Text to Columns command separates text in one column into multiple columns using a delimiter such as a comma, space, or tab. Sort & Filter and Justify do not split column data.
Last updated
Related questions
A bookmark is an item or location in document that you identify as a name for future reference. Which of the following task is accomplished by using bookmarks?
A character that is raised and smaller above the base line is known as?
A character that is raised and smaller above the baseline is known as_________?
A chart can be put as a part of the presentation using_______________ in Ms PowerPoint?
A "Ctrl + Enter" command will __________ ?