Explode Cells in Excel
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
Question? Ask it in our Excel Forum
Excel VBA Course - From Beginner to Expert
200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Tutorial: In this tutorial I am going to look at cell alignment / arrangement. These features allow ...
Tutorial: How to center a title across multiple cells in Excel in order to make good looking titles...
Tutorial: This Excel VBA tutorial focuses specifically on selecting ranges of cells in Excel. This...
Tutorial: How to allow only certain people to edit certain cells or ranges in Excel. This is a sec...
Tutorial: Forms Course How to round the corners of cells in Excel so they look so much better. This...
Tutorial: How to use VBA/Macros to iterate through each cell in a range, either a row, a column, or ...
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)