Hello,
I use this formula: ="rename """&Sheet2!E43&".csv"""
This formula gives as result: rename "Input.csv"
But I would have as a result: "Input.csv" "Input2.csv"
"Input2.csv" does not come from another worksheet. So there is just "Input2.csv" behind the formula to be typed.
Does anyone know the formula here?
Thank you,
grid
I use this formula: ="rename """&Sheet2!E43&".csv"""
This formula gives as result: rename "Input.csv"
But I would have as a result: "Input.csv" "Input2.csv"
"Input2.csv" does not come from another worksheet. So there is just "Input2.csv" behind the formula to be typed.
Does anyone know the formula here?
Thank you,
grid