Sep 10 2022 07:30 PM
A1# and E1# are spilled range, and I want to combine them to A7#. Number of row and column might change so you cannot hard code them. VBA is not allowed.
Actually I can do this with Sequence()&Mod()&Index(), but it is too long. Is there a simpler way?
Sep 10 2022 10:30 PM
You could consider joining the Office Insider Beta channel. MS has recently released some neat new functions one of which that does just that (HSTACK).
Sep 11 2022 05:18 AM