Concat() including blank values

[#1]

Hallo QV geniuses,

As the way I see it, concat() doesn't include blank values:

I have a table like this:

A	B	C
1	1	a
	2	b
3	3

when I do:

concat(A,',')

It gives me this result:

1,3

But what I want is like this:

1,,3

Is it possible?Many thanks.

[Anonymous]

I have just checked and it works fine for me.

Do beware though that it sorts the values so the null comes first and the output I get is :

    ,1,3

If you use this =concat(A,',',B) then it sorts by B and the output is :

     1,,3

[#3]

In excel, if you just leave it blank it will not work. But if you apply a space like pressing the space button it will work.

Space and blank values differ in concat(). Please try it in excel.

[Anonymous]

I do not have Excel.

[Yousef_Amarneh]

try this work around

[maxgro]

if you have an excel blank (not space) you can check it and erplace with a ''

to get 1,,3

=concat(if(len(trim(A))=0,'',A), ',', B)