Which MS Excel tool lets you import raw text file lines and split them across multiple distinct worksheet columns using a delimiter like a comma or tab? MCQ with Answer and Explanation
Which MS Excel tool lets you import raw text file lines and split them across multiple distinct worksheet columns using a delimiter like a comma or tab?
A. Merge Cells
B. Flash Fill
C. Data Validation
D. Text to Columns
Answer: Option D
Solution (By JKSSB Mock Tests)
The 'Text to Columns' wizard splits text strings from a single cell across multiple columns using defined delimiters or fixed character widths.
No comments yet. Be the first to start the discussion!