![](https://images.techhive.com/images/article/2016/03/03-select-field-delimeters-100653358-orig.png)
Microsoft Excel Help Office For Mac Convert Text To Columns Treat Consecutive Delimiters As One
![](no-image.png)
Hello everyone. This is a pretty straightforward question and I will use a dummy photo of dummy data to try and explain as easily as possible. I'm working in several files that contain multiple part numbers in a single cell. Sometimes those numbers are separated by a comma ', ' Sometimes they're NOT Sometimes the Part Numbers themselves have a ' - ' as part of the actual number. My question is there any easy way via VBA or any other method to separate those part numbers to a separate row or line item? If not this will be extremely tedious to separate manually. Please see below for a dummy data mockup of what I'm dealing with and thanks in advance.