SOLVED

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

Copper 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
best response confirmed by Mark__T (Copper Contributor)
Solution

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

1 best response

Accepted Solutions
best response confirmed by Mark__T (Copper Contributor)
Solution

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

View solution in original post