Need A Formula To Divide values Into Groups

[CARBOB]

In column G are lexicon values ranging from 000001-376992. I would like to break them into groups of 1000, starting with A1 for the first 1000; A2, 1001-2000.

Excel Workbook
	B	C	D	E	F	G	H
1	1	2	3	4	5	000001	A
2	1	2	3	4	6	000002	A
3	1	2	3	4	7	000003	A
4	1	2	3	4	8	000004	A
F5 COMBOS

Excel 2007

Cell Formulas
Range	Formula
G1	=COMBIN(36,5)-IF(33-$B1>0,COMBIN(36-$B1,5),0)-IF(33-$C1>0,COMBIN(36-$C1,4),0)-IF(34-$D1>0,COMBIN(36-$D1,3),0)-IF(35-$E1>0,COMBIN(36-$E1,2),0)-IF(36-$F1>0,COMBIN(36-$F1,1))
G2	=COMBIN(36,5)-IF(33-$B2>0,COMBIN(36-$B2,5),0)-IF(33-$C2>0,COMBIN(36-$C2,4),0)-IF(34-$D2>0,COMBIN(36-$D2,3),0)-IF(35-$E2>0,COMBIN(36-$E2,2),0)-IF(36-$F2>0,COMBIN(36-$F2,1))
G3	=COMBIN(36,5)-IF(33-$B3>0,COMBIN(36-$B3,5),0)-IF(33-$C3>0,COMBIN(36-$C3,4),0)-IF(34-$D3>0,COMBIN(36-$D3,3),0)-IF(35-$E3>0,COMBIN(36-$E3,2),0)-IF(36-$F3>0,COMBIN(36-$F3,1))
G4	=COMBIN(36,5)-IF(33-$B4>0,COMBIN(36-$B4,5),0)-IF(33-$C4>0,COMBIN(36-$C4,4),0)-IF(34-$D4>0,COMBIN(36-$D4,3),0)-IF(35-$E4>0,COMBIN(36-$E4,2),0)-IF(36-$F4>0,COMBIN(36-$F4,1))
H1	=SUBSTITUTE(ADDRESS(1,(G1-1)/1000+1,4),"1","")
H2	=SUBSTITUTE(ADDRESS(1,(G2-1)/500+1,4),"1","")
H3	=SUBSTITUTE(ADDRESS(1,(G3-1)/500+1,4),"1","")
H4	=SUBSTITUTE(ADDRESS(1,(G4-1)/500+1,4),"1","")

 

[GlennUK]

What do you mean ... "break into groups"?

 

[CARBOB]

In column G are lexicon values ranging from 000001-376992. I would like to break them into groups of 1000.

000001-001000=A1
001001-002000=A2

 

[jasonb75]

Try

="A"&INT((G1-1)/1000)+1

 

[CARBOB]

Very good, thank you!!