Discussion
In MS Excel, what does the Text to Columns feature do?
Answer: A
Correct answer: Splits the contents of one column into several columns
Text to Columns, on the Data tab, splits one column into several. It offers two methods: Delimited, splitting at a chosen character such as a comma, tab or space, and Fixed width, splitting at set positions. The typical use is separating full names, addresses or data pasted as a single line. It overwrites the columns to the right, so empty columns must be inserted first. Its third step is more useful than it looks: each resulting column can be assigned a data type, and a column can be marked Do not import to be discarded. Setting a column to Text is the standard way to stop Excel mangling account numbers and codes with leading zeros. It is also the quickest way to fix numbers stored as text - running it on a single column and clicking Finish converts them. Flash Fill, Ctrl + E, does the same job by example and is often faster; the reverse operation is CONCAT or the ampersand.
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development