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.
- Build an Infographic-Style Bar Chart in Excel
- LAMBDA – A Beginner’s Guide
- Remove Protection When Password is Unknown
- 5 Reasons Why XLOOKUP Beats VLOOKUP
- July 2021: Visual Updates to Excel
- Power Pivot and The Excel Data Model
- Storing List Based Data in Worksheet Cells: Pros v Cons
- Do You Want Early Access to Excel Updates?
- Why You Should NOT Buy Excel 2019
- Excel – Import a List of Tasks into Outlook