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?
View best response
@Mark__T , it shall work if only your list separator is comma, not semicolon. Please try to open attached file.
@Sergei Baklan Thanks! It works.