Excel Flatten function not working and not existing

Occasional Visitor



I'm trying to user Flatten Function and it seems like it doesn't exist.


And it is showing as #NAME?. I wonder what is issue.


my Excel versions is students version.


is there anyone can help me?


Thank you.

3 Replies
FLATTEN is not excel function. It is google sheet function. Use TOCOL() function in Excel.

@Harun24HR  wrote:  ``Use TOCOL() function in Excel. ``


But beware:  according to the TOCOL help page (click here}:

(Office Insider Beta only)
Windows: 2203 (Build 15104)
Mac: 16.60 (220304)



Microsoft releases all new formulas fully to Excel for web as well as Current Channel (Not only BETA Channel).