missing concatenated text values are showing up as "0" in result

asked 2019-06-15 22:45:12 +0200

tharpa gravatar image

I have cells that are concatenated text. Sometimes a "0" will appear in the result for missing values (even when there is no 0 in any of the source cells). I have tried changing the format to Text, but that causes other problems. How do I prevent it from inserting non-existent 0's?

edit retag flag offensive close merge delete


Please share a sample file for test.

m.a.riosv gravatar imagem.a.riosv ( 2019-06-16 10:48:26 +0200 )edit