Text to columns in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to split the text in cell A1 into columns using a comma as the delimiter.

Excel

Data > Text to Columns > Delimited > [1] > Finish

Drag options to blanks, or click blank then click option'

AComma

BTab

CSpace

DSemicolon

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting the wrong delimiter like Tab or Space causes incorrect splitting.

Not choosing any delimiter results in no splitting.

Choosing 'Comma' tells Excel to split the text at each comma.

2fill in blank

medium

Complete the step to specify the data format for the columns after splitting.

Excel

In the Text to Columns wizard, select [1] to set the column data format.

Drag options to blanks, or click blank then click option'

ADelimited

BGeneral

CFixed width

DText

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'Delimited' here is incorrect because it is a step before format selection.

Selecting 'Fixed width' here is for a different splitting method.

'General' format lets Excel decide the best format for each column automatically.

3fill in blank

hard

Fix the error in the step where you choose the delimiter type for splitting data.

Excel

Select [1] as the delimiter to split data separated by spaces.

Drag options to blanks, or click blank then click option'

AComma

BTab

CSemicolon

DSpace

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting 'Comma' or 'Tab' when data is separated by spaces causes wrong splitting.

Not selecting any delimiter results in no splitting.

Choosing 'Space' splits the text at each space character.

4fill in blank

hard

Fill both blanks to split data by a semicolon and set the column format to Text.

Excel

Choose [1] as the delimiter and [2] as the column data format.

Drag options to blanks, or click blank then click option'

ASemicolon

BGeneral

CText

DComma

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'General' format may convert numbers or dates automatically.

Selecting wrong delimiter causes incorrect splitting.

Selecting 'Semicolon' splits data at semicolons, and 'Text' keeps the data as text without conversion.

5fill in blank

hard

Fill all three blanks to split data by a custom delimiter '#' and set the first column as Text and the second as General.

Excel

Select [1] as delimiter, then set first column format to [2] and second column format to [3].

Drag options to blanks, or click blank then click option'

AComma

BText

CGeneral

DCustom

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'Comma' instead of 'Custom' when delimiter is '#'.

Setting all columns to 'General' may change data unintentionally.

'Custom' lets you specify '#' as delimiter. Setting first column to 'Text' keeps data as text, second column 'General' lets Excel convert data types.