Enter range in a formula

[DanielCarro]

Hi,

How do I write a range in this formula

Replace([FileName], "<List of Sheet Names>", [Sheet Names])

the range is A2:AD250

Kind Regards,

Dan

[Felipe_Ribeir0]

Hi @DanielCarro 

After this formula, you have the filename.xlsx|||sheet, right? If yes, you just need to concatenate the range like this:

[FileName] + "$A2:AD250"

Example;

output.xlsx|||Sheet1$A2:AD250

If you want to change the range dinamically (when you have a larger dataset you can have from A2 to AD400 for example), you can use the attached workflow as reference.

[DanielCarro]

Hi Felipe,

Thank you very much it worked