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?

SergeiBaklan
Diamond Contributor
Oct 09, 2025
Depends on what do you do with combined text. If show the text in another cell it shall work. If use in some formulae or as link that doesn't work.
SnowMan55
Bronze Contributor
Oct 09, 2025
I gave three suggestions. Which did you try?
In other words, show your formula (exactly).
And which version of Excel are you using?
(The CONCAT function has been available since Excel 2016, the TEXTJOIN function since Excel 2019. If you are using one of those functions with an older version of Excel, that would explain the #NAME? error.)
peiyezhu
Bronze Contributor
Oct 09, 2025
It works at my side.
if with concat, some versions of Excel do not support it.