ADVANCED

on

 

Text to Columns Command to Split Text

This Excel functionality can be used to split text in a cell into sections based on a delimiter character.


  1. Select the entire sample data range (B2:B12).
  2. Click on the Data tab in the Excel ribbon.
  3. Click on the Text to Columns icon in the Data Tools group of the Excel ribbon and a wizard will appear to help you set up how the text will be split.
  4. Select Delimited on the option buttons.
  5. Press the Next button.


Comments

Post a Comment