Solved

Excel: how to split text from numbers in cells

Posted on 2014-11-21
6
206 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
Portable, direct connect server access

The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

 

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

Create the perfect environment for any meeting

You might have a modern environment with all sorts of high-tech equipment, but what makes it worthwhile is how you seamlessly bring together the presentation with audio, video and lighting. The ATEN Control System provides integrated control and system automation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Lately there has been a variety of news related to U.S. employment.  Stories about worker productivity, automobile and airline unions, low employment and foreign laborers have frequented the news.  Each story has good and bad attributes we might arg…
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 shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

830 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