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

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

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

It contains a null text string ""

As an alternative to those using Excel 2016:

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

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

Many thanks
Works perfectly

Bob M

Much better.