TayariHub
Computer Science NULL Medium
Question

How do you split text from one column into multiple columns in Excel?

A
Data>>Sort & Filter
B
Data>>Text to Columns
✓ Official correct answer
C
Home>>Fill>>Justify
D
Home>>Editing>>Justify

Community credibility

Registered members can vote for the answer they believe is correct today and explain why. If the facts change after an election or news event, suggest a new option so others can vote it up.

A
Data>>Sort & Filter
Official option

No member explanations yet for this option.

B
Data>>Text to Columns
Official option

No member explanations yet for this option.

C
Home>>Fill>>Justify
Official option

No member explanations yet for this option.

D
Home>>Editing>>Justify
Official option

No member explanations yet for this option.

Explanation

Use Data → Text to Columns.

Related Questions

Q
How many preset margin options can be set in MS Excel?
Medium · Computer Science
Q
Which Excel feature lets you define names for use in formulas (other than Create...
Medium · Computer Science
Q
Which of the following is a common language for Artificial Intelligence?
Medium · Computer Science
Q
Who is known as the inventor (coiner) of the term Artificial Intelligence?
Medium · Computer Science