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,101

As an alternative to those using Excel 2016:

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

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 01:26 AM.