![]() |
#1
|
|||
|
|||
![]()
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 |
#2
|
||||
|
||||
![]()
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 |
#3
|
|||
|
|||
![]()
It contains a null text string ""
|
#4
|
|||
|
|||
![]() Code:
=if(A1=1,1,0)&if(B1=1,1,0)& ... &if(J1=1,1,0) |
#5
|
|||
|
|||
![]()
As an alternative to those using Excel 2016:
=CONCAT(IFERROR(VALUE(A1:A10),0)) (array-entered). (Can't be used in versions before 2016). |
#6
|
|||
|
|||
![]()
Many thanks
Works perfectly ![]() Bob M |
#7
|
|||
|
|||
![]()
Much better.
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
jimmy2016 | Excel Programming | 4 | 10-15-2016 09:05 AM |
![]() |
Yasso | Excel Programming | 1 | 12-01-2015 05:45 PM |
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 | bobznkazoo | Excel | 2 | 03-27-2014 11:14 AM |
How can I fill the below emty cells with above cell data? | Learner7 | Excel | 8 | 06-28-2011 12:10 PM |
![]() |
Learner7 | Excel | 1 | 07-28-2010 12:07 PM |