Forum Discussion
Cell Range Delimiter
I used to be able to use a period to specify a cell range in a formula, e.g. -- =sum(a1.a5). This formula now gives a #FIELD! error. It seems that Excel will only accept a colon (:) now to separate ...
BobM_48 This was broken with the release of the "Stocks and Geographies" feature which reworked how that dot operator is used. I think right now that feature is only part of Excel 2016 for Office 365.
I've actually been in contact with Microsoft about this and they've added it to their backlog to address, so this will hopefully be resolved at some point in the future.