Bird
Raised Fist0
Excelspreadsheet~5 mins

Text to columns in Excel - Cheat Sheet & Quick Revision

Choose your learning style10 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash

Start learning this pattern below

Jump into concepts and practice - no test required

or
Recommended
Test this pattern10 questions across easy, medium, and hard to know if this pattern is strong
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.
Click to reveal answer
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.
Click to reveal answer
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.
Click to reveal answer
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.
Click to reveal answer
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.
Click to reveal answer
What tab in Excel contains the Text to Columns feature?
AData
BHome
CInsert
DReview
Which option would you choose to split text by commas?
AFixed width
BText wrap
CCustom width
DDelimited
If you want to split a cell every 5 characters, which Text to Columns option do you use?
ADelimited
BFixed width
CCustom delimiter
DFlash fill
What happens if the split data overlaps existing cells?
AExcel overwrites existing cells
BExcel deletes the original data
CExcel warns and stops
DExcel moves existing data automatically
Which of these is NOT a delimiter option in Text to Columns?
ATab
BSpace
CBold
DComma
Explain how to use Text to Columns to split a full name into first and last names.
Think about splitting text by spaces.
You got /6 concepts.
    Describe the difference between Delimited and Fixed width options in Text to Columns.
    Consider how the text is separated.
    You got /4 concepts.

      Practice

      (1/5)
      1. What does the Text to Columns feature in Excel do?
      easy
      A. Splits text in one cell into multiple cells based on a separator
      B. Combines multiple cells into one cell
      C. Changes the font size of text in a cell
      D. Sorts data alphabetically

      Solution

      1. Step 1: Understand the purpose of Text to Columns

        This feature is used to split text that is combined in one cell into separate cells.

      2. Step 2: Identify the correct description

        Among the options, only splitting text based on a separator matches the feature's function.

      3. Final Answer:

        Splits text in one cell into multiple cells based on a separator -> Option A

      4. Quick Check:

        Text to Columns = Splitting text [OK]
      Hint: Remember: Text to Columns splits, not combines [OK]
      Common Mistakes:
      • Thinking it combines cells instead of splitting
      • Confusing it with sorting or formatting features
      • Assuming it changes text style
      2. Which of these is the correct first step to use Text to Columns on a cell with data separated by commas?
      easy
      A. Select the cell, right-click and choose Format Cells
      B. Select the cell, go to Data tab, click Text to Columns, choose Delimited, then select Comma
      C. Select the cell, press Ctrl+C, then paste special
      D. Select the cell, then click Sort A to Z

      Solution

      1. Step 1: Identify the correct menu path

        Text to Columns is found under the Data tab and starts with selecting the cell and clicking Text to Columns.

      2. Step 2: Choose the correct options for comma-separated data

        Choosing Delimited and then selecting Comma as the separator is the correct procedure.

      3. Final Answer:

        Select the cell, go to Data tab, click Text to Columns, choose Delimited, then select Comma -> Option B

      4. Quick Check:

        Data tab > Text to Columns > Delimited > Comma [OK]
      Hint: Always pick Delimited for separators like commas [OK]
      Common Mistakes:
      • Skipping the Data tab and looking in wrong menus
      • Choosing Fixed width instead of Delimited
      • Not selecting the correct delimiter
      3. You have a cell with the text "John;Doe;35;New York". Using Text to Columns with semicolon as delimiter, what will be the content of the third cell after splitting?
      medium
      A. 35
      B. Doe
      C. John
      D. New York

      Solution

      1. Step 1: Split the text by semicolon delimiter

        The text splits into four parts: "John", "Doe", "35", and "New York".

      2. Step 2: Identify the third part after splitting

        The third part is "35" which will be placed in the third cell.

      3. Final Answer:

        35 -> Option A

      4. Quick Check:

        Third split part = 35 [OK]
      Hint: Count parts after splitting; third part is third cell [OK]
      Common Mistakes:
      • Confusing the order of split parts
      • Using wrong delimiter
      • Assuming spaces affect splitting
      4. You tried to split a cell with data "apple orange banana" using Text to Columns but selected comma as delimiter. What is the result?
      medium
      A. Excel shows an error message
      B. The text splits into three cells: apple, orange, banana
      C. The text splits into two cells: apple orange, banana
      D. The entire text stays in one cell

      Solution

      1. Step 1: Understand the delimiter effect

        Since the text uses spaces but the delimiter chosen is comma, no splitting occurs.

      2. Step 2: Predict the result of incorrect delimiter choice

        Text remains in one cell because no commas exist to split on.

      3. Final Answer:

        The entire text stays in one cell -> Option D

      4. Quick Check:

        Wrong delimiter = no split [OK]
      Hint: Match delimiter to actual separator in text [OK]
      Common Mistakes:
      • Expecting split without correct delimiter
      • Thinking Excel auto-detects delimiter
      • Assuming error shows for wrong delimiter
      5. You have a list of full names in one column like "Anna Smith", "Bob Lee", and want to split first and last names into two columns. Which steps correctly achieve this using Text to Columns?
      hard
      A. Select the column, Data tab, Text to Columns, choose Fixed width, set break after first name
      B. Select the column, Home tab, click Merge & Center
      C. Select the column, Data tab, Text to Columns, choose Delimited, select Space as delimiter
      D. Select the column, Insert tab, click Table

      Solution

      1. Step 1: Choose the correct splitting method for space-separated names

        Since names are separated by spaces, Delimited with Space delimiter is appropriate.

      2. Step 2: Apply Text to Columns with Space delimiter

        This splits first and last names into separate columns correctly.

      3. Final Answer:

        Select the column, Data tab, Text to Columns, choose Delimited, select Space as delimiter -> Option C

      4. Quick Check:

        Space delimiter splits first and last names [OK]
      Hint: Use Delimited with space for splitting names [OK]
      Common Mistakes:
      • Using Fixed width which is harder to set correctly
      • Trying to merge cells instead of splitting
      • Confusing Insert Table with splitting text