Split Multiple CSV or Line Break Values from One Cell to Multiple Columns or Rows

Check out my Blog: http://exceltraining101.blogspot.com Have you ever gotten a file of serial number (or other list type of values) that were combined into one cell? What you really wanted was to have this listed out separately. Sometimes you were lucky that they were separated (or delimited) by commas or other common separators like semicolons. However if it was separated from some unknown character like a line break (paragraph break or line feed) that would be a bit more tricky...or not. This video show how to pull out those values and have the output in separate columns or rows. Check it out. P.S. Feel free to provide a comment or share it with a friend! --------------------- Excel Training: https://www.exceltraining101.com/p/training.html Excel Books: https://www.amazon.com/shop/dough