mkidmanCopper ContributorOct 03, 2025Adding Cell Value to file string Hi, I want to add the value of Cell C11 to a file string. So C:\user\ (Value of C11).XLSM Is there any easy way of doing this or do I need to use VBA? Thank you! Show More
SnowMan55Bronze ContributorOct 03, 2025String 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.
