Which of the following utility options under the MS Excel Data tab allows developers to split a single column of text data into multiple columns using a delimiter like a comma?
Explanation:
The 'Text to Columns' wizard splits text strings from a single cell across multiple columns based on a specified delimiter (such as a tab, comma, or space) or a fixed character width.
No comments yet. Be the first to start the discussion!