Thanks for your help Glenn.

Yes, I changed the commas for semicolons. By the way, there is no need to check for multiple spaces, I made sure of that with regular expressions.

The document is a .csv not Excel format though I don't think that matters, right? This is what I see:

https://i.imgur.com/mOgbi23.gif

The first occurence shows correctly when entering the array formula but when I drag nothing happens.

This is a subset of my original file (13KB) in case it helps https://drive.google.com/open?id=0Bw...lQ3OHdvN28wa1k

PS: Hope you are having a nice time in Cataluņa