Forum Discussion

Copper Contributor

Oct 03, 2025

Adding 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!

excel

SnowMan55

Bronze Contributor

Oct 03, 2025

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.

mkidman

Copper Contributor

Oct 08, 2025

Hi SnowMan55,

I did try your suggestion but it returned the #Name?