1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Formula to show result after pressing F2 and F9

I have a formula like =COLUMN(A:B). When I select this formula, press F2 and then F9 it returns {1\2}

(On my system " \" is column separator).

My question: Is there any formula can return the same result as when pressing first F2 and then F9, that is (in my situation) {1\2}

submitted by /u/HansKnudsen
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article