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

Tagged with

#AI formula generation techniques
#formula generator
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#formula
#COLUMN
#F2
#F9
#{1\2}
#A:B
#Excel
#result
#separator
#system
#return
#selected
#question
#submitted