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
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 not only gives the respective formulas but it also explains how each formula is working to achieve the goal.