A. Data>>Sort & Filter
B. Data>>Text to Columns
C. Home>>Fill>>Justify
D. Home>>Editing>>Justify
Submitted by: Aon Ali Gopang
Explanation:
Data >> Text to Columns → Splits the contents of one column into multiple columns (e.g., splitting “First Last” into separate First Name and Last Name columns).
Data >> Sort & Filter → Used for sorting and filtering data, not splitting.
Home >> Fill >> Justify → Adjusts text alignment, does not split data.
Home >> Editing >> Justify → Also about alignment, not splitting.
Example:
If a column contains values like “Ali Khan”, using Text to Columns with space (“ ”) as the delimiter will split them into “Ali” and “Khan” in two separate columns
The correct answer to the question: "How to split a single columns’ text into multiple columns?" is "Data>>Text to Columns".
