split the contents in a cell without delimiters

[Ninpike]

How do I separate text and numbers in a cell without delimiters? For example, if I had a cell that had "C2b45", how could I get it to put C in one cell, 2 in another, b in another, 4 in another, 5 in another?

[#2]

@Ninpike If your Excel version supports dynamic array functions, you could use this: