Combine 2 spilled range to one

Question

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?

riny_van_eekelen · Answer

qazzzlyt&nbsp;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).&nbsp;

qazzzlyt · Answer

Thank you for the information! Would you by any chance have a link for that? I just tried but cannot find the link.

riny_van_eekelen · Answer

qazzzlyt&nbsp;Start here:https://support.microsoft.com/en-us/topic/join-the-office-insider-program-3c7dda4f-4d05-0783-3a9a-182b50acb8a9&nbsp;

Forum Discussion

Combine 2 spilled range to one

Share

Resources