Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-05-2017, 11:33 AM
xor xor is offline Combining several cells data into one single cell Windows 10 Combining several cells data into one single cell Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default


As an alternative to those using Excel 2016:

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

(Can't be used in versions before 2016).
Reply With Quote
  #2  
Old 01-09-2017, 06:00 AM
gebobs gebobs is offline Combining several cells data into one single cell Windows 7 64bit Combining several cells data into one single cell Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Quote:
Originally Posted by xor View Post
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.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Combining several cells data into one single cell Combining different worksheets into a single worksheet. jimmy2016 Excel Programming 4 10-15-2016 09:05 AM
Combining several cells data into one single cell 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
Combining several cells data into one single cell 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 09:26 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft