CONCAT formula doesn't work for a simple table of contents

New Contributor

Hi all,

I'm trying to create a table of contents with Excel 2016. 

I am using the CONCAT formula but excel give me error as You can see in the picture.


Can You help me to fix the error?



2 Replies

@Mark__T , it shall work if only your list separator is comma, not semicolon. Please try to open attached file.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies