How to shorten a formula and remove commas from empty boxes?
Hello
Is it possible to shorten the formula and remove commas from empty boxes?
Thanks Ryszard
[Re-Titled by Moderator]
MacBook Air 13″, macOS 15.4
You can use the TEXTJOIN function.
In I2, filled down:
=TEXTJOIN(",",1,A2:G2)
Which should appear as:
=TEXTJOIN(“,”,TRUE,A2:H2)
The TRUE means skip blank cells.
More on TEXTJOIN here:
Use ; instead of , in the formula if your region uses , as the decimal separator.
=TEXTJOIN(",";1;A2:G2)
SG