Is it possible to generate a string from the syntax of a parameter?

[Rnkhch]

Hello,

Would it be possible to output a string corresponding to the syntax of a parameter? Here is an example:

=LET(x,A5:H5,operation...)

Would it be possible to have a function in place of "operation" that would get the string output of the second parameter's syntax as "A5:H5" (without the quotes)?

(Everything I tried so far generate strings from the actual contents of A5:H5.)

Thanks for any input!

 

[JvdV]

Unsure what exactly you are after, try:

=INDEX(A:H,5,0)

If that isn't helpfull, could you please show with an example what it is you are trying?

 

[shaowu459]

if I get you right:

工作簿1
	A	B	C	D	E	F
1
2
3				$A$5:$H$5
4
5
6
Sheet1

Cell Formulas
Range	Formula
D3	D3	=LET(s,MAP(A5:H5,LAMBDA(x,CELL("address",x))),TAKE(s,,1)&":"&TAKE(s,,-1))

 

[shaowu459]

or you can try:

工作簿1
	A	B	C	D	E	F
1
2
3				$A$5:$H$5
4
5
6
Sheet1

Cell Formulas
Range	Formula
D3	D3	=LET(x,A5:H5,CELL("address",TAKE(x,1,1))&":"&CELL("address",TAKE(x,-1,-1)))

 

[JEC]

Or

=LET(r,A5:H5,x,ADDRESS(ROW(r),COLUMN(r),4),TAKE(x,1,1)&":"&TAKE(x,-1,-1))

 

[shaowu459]

工作簿1
	A	B	C	D	E	F	G	H	I
1
2					$A$5:$H$7
3
4
5
6
7
8
Sheet1

Cell Formulas
Range	Formula
E2	E2	=LET(x,A5:H7,CELL("address",TAKE(x,1,1))&":"&CELL("address",TAKE(x,-1,-1)))

 

[Rnkhch]

Thanks all! I wanted to use the output string as a reference in INDIRECT.