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
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies