I'm concatenating (is that a word?!) a range of data into one cell using the =CONCATENATE function.
However, I want the function to ignore and skip any cell which has a '0' in.
for example, data:
I want to see A5= 79, but have A5= 709