Quote Originally Posted by Excel Fox View Post
What's your formula separator? Is it : or something else?

Also, can you test this on a much smaller sample.. maybe 10000 rows and 17 columns.... If it works, then I'll come up with something else. If it doesn't work, then something's wrong with the data.

On 10000 rows it removed all the content and then displayed the same error in the same line.

My formula separator seems to be , and not :