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
colin_thamesAsked:
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

=left(A2,1)

and cell C2 would be

=mid(a2,2,999)
0
 
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.
0
 
colin_thamesAuthor Commented:
Sorry, each cell in the column has one letter and one number, eg
A1
D4
C3
E5

I want to split each cell into two columns, one for the letter and one for the number
0
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?
0
 
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.
0
 
colin_thamesAuthor Commented:
Many thanks Philip, both for speed and a real simple solution
0
All Courses

From novice to tech pro — start learning today.