Solved

Excel: how to split text from numbers in cells

Posted on 2014-11-21
6
216 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

 

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

With the internet and the ease of information transference, many professional jobs can be done anywhere today.  Why should it make a difference whether an x-ray is read in India or the United States as long as the radiologist is qualified?   Outso…
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 an MLA formatted document, as well as a bibliography with citations.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

738 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