Combining several cells data into one single cell

[H28Sailor]

Hi

I have say 10 cells which hold data originating from survey software (radio buttons)
Each of these cells has either a '1' in it or is blank



e.g. 1 blank blank 1 blank blank 1 blank blank blank

Is there a way to combine these results into a new cell which holds the following data

1001001000

Thanks

Bob M

[Pecoflyer]

When you say a blank cell is it really empty or does it contain a null text string "" or non printable characters ?

[H28Sailor]

It contains a null text string ""

[gebobs]

=if(A1=1,1,0)&if(B1=1,1,0)& ... &if(J1=1,1,0)

[xor]

As an alternative to those using Excel 2016:

=CONCAT(IFERROR(VALUE(A1:A10),0)) (array-entered).

(Can't be used in versions before 2016).

[H28Sailor]

Many thanks
Works perfectly

Bob M

[gebobs]

Originally Posted by xor

As an alternative to those using Excel 2016:

=CONCAT(IFERROR(VALUE(A1:A10),0)) (array-entered).

(Can't be used in versions before 2016).

Much better.