Adding Cell Value to file string

Question

Hi,&nbsp;I want to add the value of Cell C11 to a file string.So C:\user\ (Value of C11).XLSMIs there any easy way of doing this or do I need to use VBA?Thank you!&nbsp;

snowman55 · Answer

String literals and/or string values can be concated in a couple of ways in a formula. The simplest is to use the concatenation operator (&):

="C:\user\" & C11 & ".XLSM"

Alternatives include the CONCAT function and the TEXTJOIN function.

Forum Discussion

Adding Cell Value to file string

1 Reply

Resources