Two changes:
In S5
=SUBSTITUTE(SUBSTITUTE(L5 & ","&M5& ","&N5& ","&O5& ","&P5& ","&Q5,",","")," ","")
I cannot remove zeros as you have codes such C10 , P10
in U5
Formula:
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(S5,1,""),2,""),3,""),4,""),5,""),6,""),7,""),8,""),9,""),0,"")
If you are on latest Excel there is function TEXTJOIN which can be used instead of above
in V5
=LEN($U5)
This illustrates the (major) disadvantage of using text strings to record data. Complete redesign of data collection/input ???? !!!!
You could hide columns S and U if required.
I have not done a comprehensive check that nothing else is impacted by these changes.
Bookmarks