Excel: how to split text from numbers in cells

Can anyone give a quick hand?
I've got a spreadsheet with scores for nearly 2000 rows in the format: letter, number. eg A1, C2, B1, B4, C3, D5 and so on.  Each cell has only one letter and one number.
I want to split the letters and numbers into adjacent rows.
Is there a formula or method I can apply?
I'm using Excel 2010
Who is Participating?
Phillip BurtonConnect With a Mentor Director, Practice Manager and Computing ConsultantCommented:
If that is column A starting in cell A2, then cell B2 would be


and cell C2 would be

Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
Is all of this "A1, C2, B1, B4, C3, D5" in one cell, or in several cells?

Need a bit more specifics.
colin_thamesAuthor Commented:
Sorry, each cell in the column has one letter and one number, eg

I want to split each cell into two columns, one for the letter and one for the number
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

colin_thamesAuthor Commented:
Perfect, that works, thanks.
Can I just check what the 999 refers to?
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
It's just a very long number - much longer than you need, but there's no harm in having such a long number.
colin_thamesAuthor Commented:
Many thanks Philip, both for speed and a real simple solution
All Courses

From novice to tech pro — start learning today.