Simple text behind a worksheet formula with quotes.

[grid]

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

 

[VoG]

Try

=""""&Sheet2!E43&".csv"""&" " &""""&Sheet2!E43&"2.csv"""

 

[grid]

Thanks for the quick response. I have this now: =""""&Sheet2!E43&".csv"""&" " &"""Input2.csv"""

This works well. But perhaps it can be shorter since no 2nd time I refer to another range.

Thank you,

grid

 

[Norie]

grid

What do you mean by 'no 2nd time I refer to another range'?

 

[grid]

I only need 1x to retrieve text from Sheet2


Regards,

grid

 

[Norie]

grid

The formula Peter posted only has one cell reference, just as your's had.

 

[grid]

But it will get a value from E43 again. I did not need that twice


Regards,

grid

 

[Norie]

No it won't.

It only has one cell reference - Sheet2!E43.

Or am I missing something?

 

[VoG]

Here's an alternative that avoids the need for multiple "s in the formula

=CHAR(34)&Sheet2!E43&".csv"&CHAR(34)&" "&CHAR(34)&"Input2.csv"&CHAR(34)

 

[grid]

Thank you for the alternative. The question is solved


Regards,

grid