Before 365, this needs to be entered into the CONCATENATE function one by one, not to mention the commas in between. With Excel 365, use the function: ARRAYTOTEXT. Bingo!
Say the range of text resides in A1:A9. All you need to input is
=ARRAYTOTEXT(A1:A9)
This makes our life so much easier! 😉
New Generation Finance - Accounting - Controlling using Microsoft BI stack
A Power BI Creator Blog
Work smarter by Mastering Functions in Excel
Work smarter by Mastering Functions in Excel
Helping lawyers make the most of Microsoft Excel
Work smarter by Mastering Functions in Excel
Work smarter by Mastering Functions in Excel
Work smarter by Mastering Functions in Excel
Peltier Technical Services - Excel Charts and Programming
Turn your data into opportunity
Q&A about Excel
Doug Glancy's Excel Site
wmfexcel 