Hi,

I am using the ADDRESS function in combination with the INDIRECT function to reference different values. Part of the string in the ADDRESS function changes, is there a way I can use a cell value as part of the string.

=ADDRESS(1,2,1,TRUE,"[Book1]III.csv")

only the III (in blue) needs to change. Is there a way I can refer this to a cell value, which could then be changed easily.

Thanks,

Bertie.