![]() |
|
#1
|
|||
|
|||
![]() As an alternative to those using Excel 2016: =CONCAT(IFERROR(VALUE(A1:A10),0)) (array-entered). (Can't be used in versions before 2016). |
#2
|
|||
|
|||
![]()
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 |