Combining several cells data into one single cell

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

01-09-2017, 06:00 AM

gebobs

Windows 7 64bit Combining several cells data into one single cell

Office 2010 64bit

Expert

Join Date: Mar 2014

Location: Atlanta

Posts: 837

Quote:

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.

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 07:19 PM.