I have it in my cells A5:

A:E

and in my cell B6, I have it :

3

I try to say in other cells :

A3:E3

to select all row from A3 to E3

I tried to use Concat with excel but it put me error thanks for reading me

CodePudding user response：

EDIT

Is this what you are trying to achieve, as

CodePudding user response：

Try:

=LEFT(A1;FIND(":";A1)-1)&A2&RIGHT(A1;FIND(":";A1))&A2

A2 contains "3", A1 contains "A:E"