Extracting numbers in serial order

[ironsides]

I have Line 1 column A having 15 numbers. I want to insert 3 columns (B, C and D). Col B to have the first 5 of the numbers that is in col A, Col C to have the middle 5, and Col D to have to last 5. Is there a formula for this? Thank you, Ironsides.

 

[Krishnakumar]

Hi,

Try,

Data->Text to Columns and check Fixed width.

HTH

 

[Aladin Akyurek]

I took your source spec as column A housing N numbers in a multicell range...

Book3
	A	B	C	D
1	0	5	5	5
2	List0	List1	List2	List3
3	2	2	9	7
4	3	3	8	4
5	6	6	0	2
6	4	4	5	1
7	8	8	0	15
8	9
9	8
10	0
11	5
12
13	7
14	4
15	2
16	1
17	15
Sheet1

A1 must house a 0.

B1:D1 houses the number of items to extract from column A...

B3, copied across then down:

=IF(ROW()-ROW(B$3)+SUM($A$1:A$1)+1<=SUM($A$1:B$1),INDEX($A$3:$A$17,ROW()-ROW(B$3)+SUM($A$1:A$1)+1),"")