This week I received an email from someone who had 258 cells containing strings that they wanted to combine into a single cell. Rather than using VBA, I worked out another way to do it. This video shows you how. Note that the CONCATENATE function has a limit of 255 arguments so you’d have to use the solution from this video plus some manual concatenation.
Recent Tutorials
- Do You Want Early Access to Excel Updates?
- Why You Should NOT Buy Excel 2019
- Excel – Import a List of Tasks into Outlook
- Excel – NEW in March 2018: Geography and Stock Data Types
- Excel – Create a Pivot Table Using Excel Online
- INDEX & MATCH v VLOOKUP / HLOOKUP
- Excel Slicers – 2 Pivot Tables Based on Different Data Sources
- Excel 2010 – Create a Combo Chart
- Power Pivot and Power Query
- Excel – What is a Dashboard?
Very helpful! Thanks.