Using Excel 2010
Hello,
I get 5 numbers into 1 cell, in the column “D” separated by one space. I want to put them into separated cells in the columns F through J and sum in the column K
Please help with formula or VBA….below are the example data.
Thank you.
Regards,
Moti
Hello,
I get 5 numbers into 1 cell, in the column “D” separated by one space. I want to put them into separated cells in the columns F through J and sum in the column K
Please help with formula or VBA….below are the example data.
Excel Question ExcelFourms.xls | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | |||
1 | ||||||||||||||
2 | ||||||||||||||
3 | Numbers | |||||||||||||
4 | Seperated | |||||||||||||
5 | By Space | n1 | n2 | n3 | n4 | n5 | Sum | |||||||
6 | 1 2 4 5 7 | 1 | 2 | 4 | 5 | 7 | 19 | |||||||
7 | 1 2 3 4 10 | 1 | 2 | 3 | 4 | 10 | 20 | |||||||
8 | 1 2 3 32 50 | 1 | 2 | 3 | 32 | 50 | 88 | |||||||
9 | 1 2 3 33 49 | 1 | 2 | 3 | 33 | 49 | 88 | |||||||
10 | 1 2 24 29 31 | 1 | 2 | 24 | 29 | 31 | 87 | |||||||
11 | 1 2 25 27 32 | 1 | 2 | 25 | 27 | 32 | 87 | |||||||
12 | 9 32 34 35 36 | 9 | 32 | 34 | 35 | 36 | 146 | |||||||
13 | 9 32 33 34 39 | 9 | 32 | 33 | 34 | 39 | 147 | |||||||
14 | 10 16 17 21 22 | 10 | 16 | 17 | 21 | 22 | 86 | |||||||
15 | 10 16 25 40 43 | 10 | 16 | 25 | 40 | 43 | 134 | |||||||
16 | ||||||||||||||
17 | ||||||||||||||
18 | ||||||||||||||
Sheet4 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
K6:K15 | K6 | =SUM(F6:J6) |
Thank you.
Regards,
Moti