# Excel: Separating Letters and Numbers

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 ad1c9bdddfhttps://brainmass.com/computer-science/programming-languages/excel-separating-letters-numbers-534548

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