Hello, I don't know what an m-dash character is, or where to findit on my keyboard, I tried everything that looked like a hyjhen and nothing worked, then I copied it from the column A cell and pasted into the delimeter field and it worked fine. Thanks for your help! I will mark this thread resolved.