Excel 2008 (MAC) - Function to concatenate range of values?
Posted on 2011-09-13
So frustrating that Excel 2008 seems to have killed VBA... Any potential solution I find is obsolete...
Basically, I'm trying to concatenate a range of values. I keep finding references to MCONCAT, which seems great, but isn't available for 2008... Is there a way to accomplish the same thing using functions?
If I want to concatenate data between A1:A8, is there a way to do it without having to type each individual cell name? Alternatively, is there a way to concatenate a series of numbers between two values? For example, is there a function that would accept 1,10 as arguments and output 1,2,3,4,5,6,7,8,9,10?