Forum Discussion

Modnar1's avatar
Modnar1
Copper Contributor
Nov 18, 2022
Solved

Need help with Textjoin or concat function

So I have a row of fields and most will contain a number that to me has a value assigned to it. The value is not important and will be manipulated elsewhere. What I need is a summary of those values ...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Nov 18, 2022

    Modnar1 

    =TEXTJOIN(".",,IF(ISBLANK(A2:I2),TEXT(A2:I2,"0"),A2:I2))

    You can try this formula which returns the intended result in my sheet.

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Nov 18, 2022

Modnar1 

=TEXTJOIN(".",,IF(ISBLANK(A2:I2),TEXT(A2:I2,"0"),A2:I2))

You can try this formula which returns the intended result in my sheet.

Resources