https://techcommunity.microsoft.com/discussions/excelgeneral/concantenate-and-ignore-0s/4072278
Concantenate and Ignore 0s | Microsoft Community Hub
I am making a template. Sheet 2 is the input sheet for data, Sheet 1 moves that data from Sheet 2 into Sheet 1 and adds a column with a concatenate formula...
microsoft communityignorehub