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.

mkidman · Answer

Hi SnowMan55,&nbsp;I did try your suggestion but it returned the #Name?

peiyezhu · Answer

It works at my side.if with concat, some versions of Excel do not support it.

snowman55 · Answer

I gave three suggestions.&nbsp; 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.&nbsp; If you are using one of those functions with an older version of Excel, that would explain the #NAME? error.)

sergeibaklan · Answer

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.

Forum Discussion

Adding Cell Value to file string

5 Replies

Resources