Microsoft Excel Help Office For Mac Convert Text To Columns Treat Consecutive Delimiters As One
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.