Purchase Solution

Excel: Separating Letters and Numbers

Not what you're looking for?

Ask Custom Question

I have a spreadsheet where one column has cells with letters and numbers (see attachment). I want to separate the letters into one cell and the numbers (highlighted in red) into another cell. Please provide the formula for how it can be done.

Attachments
Purchase this Solution
Solution Summary

Solution not only gives the respective formulas but it also explains how each formula is working to achieve the goal.

Solution Preview

Format of Description column is as shown below:

variable_length_word 9_digit_number HAR

Note that there are two spaces in the above description format.

1. Separating the number from the Description (column D) into column E:

Select the column E rows 2-13, and then type the formula for cell E2 (as mentioned below) and then hit Ctrl+Enter to copy the formula to all the cells in the ...

Purchase this Solution
Free BrainMass Quizzes
Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

C# variables and classes

This quiz contains questions about C# classes and variables.

Basic Networking Questions

This quiz consists of some basic networking questions.

View More Free Quizzes
Related BrainMass Solutions

  • Chiper code in C++

    LOWERCASE LETTERS), and from "0" to "9" for all of the NUMBERS. and use the process of elimination to let it GENERATE each RANDOM character.

  • Dividend Adjustment Model

    line are lower numbers that go to the right and directly under the letters - it is difficult to type the problem) Please see the attached Excel 97-2003 spreadsheet.

  • Counting, probability and normal probability plot

    If repetitions of letters and numbers are not allowed, how many possible passwords are there? (b) Tickets for international cricket matches between Australia and England are very popular.

  • Combinations of Letters and Numbers : Forming License Plate Numbers

    letters and numbers in license plates are investigated.

  • Java Sample Program: Grading Application

    if letters was entered Welcome to Grading Pro Will you be entering numbers or letters? Enter 'numbers' or 'letters' letters Enter a letter in String format C 70-79 - C Press any key to continue . . .

  • Number of possible combinations of alphabets

    d) How many 10-letter words can the tribe have that contain exactly 5 E's, 3 R's, and 2 T's? Suppose that in a lottery you choose 5 numbers out of 47. Five numbers are then drawn and you win a prize if you have at least 3 of the 5 numbers.

  • Combinations

    Totally there are 10 numbers and 26 letters for you to choose. I am not sure which scenario you are talking about? Can you have repeating numbers or letters?

  • Combination and Permutation

    There are 26 letters and 10 digits. since repetition is allowed then we may choose these these letters by 26 ways and 0 is leading numbers thus first digit can be chosen by 10 ways and similarly others can be chosen by 10 ways respectively.

  • Assessment for Phonemic Awareness

    Last you can have the students break apart the words by sound, separating the letters which is the Yopp-Singer Test of Phonemic Segmentation. For this last too, a 22 word test is given to provide for the assessment.

View More Related Solutions