Forum Discussion
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 ...
=TEXTJOIN(".",,IF(ISBLANK(A2:I2),TEXT(A2:I2,"0"),A2:I2))You can try this formula which returns the intended result in my sheet.
Thanks that works, I knew that some easy way existed...