Explore BrainMass
Share

Explore BrainMass

    Excel: Separating Letters and Numbers

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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.

    © BrainMass Inc. brainmass.com October 10, 2019, 6:13 am ad1c9bdddf
    https://brainmass.com/computer-science/programming-languages/excel-separating-letters-numbers-534548

    Attachments

    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 ...

    Solution Summary

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

    $2.19