Solved

Excel: how to split text from numbers in cells

Posted on 2014-11-21
6
183 Views
Last Modified: 2014-11-21
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
0
Comment
Question by:colin_thames
  • 3
  • 3
6 Comments
 
LVL 24

Expert Comment

by:Phillip Burton
ID: 40457644
Is all of this "A1, C2, B1, B4, C3, D5" in one cell, or in several cells?

Need a bit more specifics.
0
 

Author Comment

by:colin_thames
ID: 40457654
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
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
ID: 40457665
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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:colin_thames
ID: 40457697
Perfect, that works, thanks.
Can I just check what the 999 refers to?
0
 
LVL 24

Expert Comment

by:Phillip Burton
ID: 40457706
It's just a very long number - much longer than you need, but there's no harm in having such a long number.
0
 

Author Closing Comment

by:colin_thames
ID: 40457735
Many thanks Philip, both for speed and a real simple solution
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Meetings to discuss business process can waste time, and often do .  The meeting's dialog can get confusing when participants have different professional perspectives and backgrounds.  A jointly-developed process picture helps wade through the confu…
This article will shed light on the latest trends when it comes to your resume building needs. For far too long, the traditional CV format has monopolized the recruitment market.
This video walks the viewer through the process of creating a watermark for their document, customizing it, and saving it for viewing/printing needs.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now