Text to columns in Excel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the Text to Columns feature do in Excel?

It splits the content of one cell into multiple cells based on a delimiter or fixed width. For example, separating first and last names from one cell into two cells.

beginner

Which delimiter options can you use in Text to Columns?

Common delimiters include commas, spaces, tabs, semicolons, or you can specify a custom character to split the text.

beginner

How do you start the Text to Columns wizard in Excel?

Select the cells you want to split, then go to the Data tab and click on the 'Text to Columns' button.

intermediate

What is the difference between Delimited and Fixed width in Text to Columns?

Delimited splits text based on characters like commas or spaces. Fixed width splits text at specific character positions you set.

intermediate

Can Text to Columns overwrite existing data in adjacent cells?

Yes, if the split data extends into cells that already have content, Excel will overwrite those cells without warning. Always check before applying.

What tab in Excel contains the Text to Columns feature?

A Data

B Home

C Insert

D Review

The Text to Columns feature is found under the Data tab in Excel.

Which option would you choose to split text by commas?

A Fixed width

B Text wrap

C Custom width

D Delimited

Delimited option lets you split text by characters like commas.

If you want to split a cell every 5 characters, which Text to Columns option do you use?

A Delimited

B Fixed width

C Custom delimiter

D Flash fill

Fixed width splits text at set character positions.

What happens if the split data overlaps existing cells?

A Excel overwrites existing cells

B Excel deletes the original data

C Excel warns and stops

D Excel moves existing data automatically

Excel overwrites existing cells without warning when splitting data.

Which of these is NOT a delimiter option in Text to Columns?

A Tab

B Space

C Bold

D Comma

Bold is a text format, not a delimiter.

Explain how to use Text to Columns to split a full name into first and last names.

Think about splitting text by spaces.

Describe the difference between Delimited and Fixed width options in Text to Columns.

Consider how the text is separated.