I need help with an Excel formula to extract text and numbers into separate columns. I’m using Excel 2016 and have data in cells A1 to A4, as follows:

A1: abc
A2: 123
A3: def
A4: 456
A5: ghi
A6: 789
A7: jkl

I want to get the text values in one column (e.g., B1 to B4) and the number values in another column (e.g., C1 to C4). How can I achieve this?

Any guidance would be greatly appreciated!

Thanks!