Char Function to pull the column Name

[sksanjeev786]

Hi Team,

With the help of the Char function, i am able to pull the column name till 25 columns but after that not able to pull
Can anyone help me with this?

FS.xlsm
	F	G	H	I	J	K	L	M	N	O	P	Q	R
50										AB	AE	AH	AK
51	B	D	G	J	M	P	S	V	Y	\	_	b	e
52	2	4	7	10	13	16	19	22	25	28	31	34	37
Dig.Delta

Cell Formulas
Range	Formula
F51:R51	F51	=CHAR(F52+64)
F52:R52	F52	=F2

 

[Fluff]

In future please copy data that we can copy your formula in row 52 is looking at row 2 which is not included.

How about

Fluff.xlsm
	F	G	H	I	J	K	L	M	N	O	P	Q	R
1
2	B	D	G	J	M	P	S	V	Y	AB	AE	AH	AK
3	2	4	7	10	13	16	19	22	25	28	31	34	37
Main

Cell Formulas
Range	Formula
F2:R2	F2	=SUBSTITUTE(ADDRESS(1,F3,4),"1","")

 

[sksanjeev786]

In future please copy data that we can copy your formula in row 52 is looking at row 2 which is not included.

How about

Fluff.xlsm
	F	G	H	I	J	K	L	M	N	O	P	Q	R
1
2	B	D	G	J	M	P	S	V	Y	AB	AE	AH	AK
3	2	4	7	10	13	16	19	22	25	28	31	34	37
Main

Cell Formulas
Range	Formula
F2:R2	F2	=SUBSTITUTE(ADDRESS(1,F3,4),"1","")

Simply Fabulous

Thank you so much Fluff

And sure moving farward i will keep my data from Starting row onwards

 

[Fluff]

Glad to help & thanks for the feedback.