Combining several cells data into one single cell

		Microsoft Office Forums > Microsoft Excel > Excel
Combining several cells data into one single cell

01-05-2017, 11:33 AM

xor

Windows 10 Combining several cells data into one single cell

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,097

As an alternative to those using Excel 2016:

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

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Combining different worksheets into a single worksheet.	jimmy2016	Excel Programming	4	10-15-2016 09:05 AM
Help on separate a single text cell into multi cells by coding	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
How to combine different cells data in one cell?	Learner7	Excel	1	07-28-2010 12:07 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:46 AM.