Explode Cells in Excel

Add to Favorites
Author: | Edits: don

Excel formula to split up every character in a cell. This allows you to make really complex formulas that do things like verify patterns or check cell contents. You also learn how to check the cde for each character so you can more easily do things like check for hidden spaces or check for lists of allowed characters.

(Courtesy of a youtube comment from Wayne.)

Regular Version

=MID(A2,SEQUENCE(LEN(A2)),1)

Code Version

=CODE(MID(A2,SEQUENCE(LEN(A2)),1))

Other Resources


Excel Version: Excel 2019, Excel 365
Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Our Excel Courses

Professional Input Forms in Excel

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

Send Emails from Excel

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

Similar Content on TeachExcel
How to Arrange Data within Cells in Excel
Tutorial: In this tutorial I am going to look at cell alignment / arrangement. These features allow ...
Center Titles Across Multiple Cells in Excel
Tutorial: How to center a title across multiple cells in Excel in order to make good looking titles...
Select Ranges of Cells in Excel using Macros and VBA
Tutorial: This Excel VBA tutorial focuses specifically on selecting ranges of cells in Excel.  This...
Allow Only Certain People to Edit Specific Cells in Excel
Tutorial: How to allow only certain people to edit certain cells or ranges in Excel. This is a sec...
Make Rounded Corner Cells in Excel
Tutorial: Forms Course How to round the corners of cells in Excel so they look so much better. This...
Loop through a Range of Cells in Excel VBA/Macros
Tutorial: How to use VBA/Macros to iterate through each cell in a range, either a row, a column, or ...
Tutorial Details
Excel Version: Excel 2019, Excel 365
Downloadable Files: Excel File
Similar Content
How to Arrange Data within Cells in Excel
Tutorial: In this tutorial I am going to look at cell alignment / arrangement. These features allow ...
Center Titles Across Multiple Cells in Excel
Tutorial: How to center a title across multiple cells in Excel in order to make good looking titles...
Select Ranges of Cells in Excel using Macros and VBA
Tutorial: This Excel VBA tutorial focuses specifically on selecting ranges of cells in Excel.  This...
Excel Forum