Forum Discussion
Text aggregating in a single cell
Hello, I realize this is a big question and I'm trying to do several things at once so any help/ ideas/ recommendations are welcome. Anyone who wants to swing big and solve the whole thing for me...
It would be simpler if you had Microsoft 365 or Office 2021.
Here is a solution that'll work in all versions using a custom VBA function; the workbook is now a macro-enabled workbook (.xlsm).
I couldn't agree more. I would love to have access to 365 or 2021, but I'm the only excel nerd on my team at work and nobody else cares about an upgrade.
I haven't had any experience with Macros or VBA-enabled workbooks in the past but after 15 minutes of playing with what you sent back, I now know it's the next thing I need to learn. It seems to be working like a charm for exactly what I need it to do and will allow me to disseminate information much more easily amongst the people I work with.
Thank you so very much for your help. HansVogelaar
