SOLVED

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?

 

concat.JPG

2 Replies
Highlighted
Best Response confirmed by Mark__T (New Contributor)
Solution

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

Highlighted