Рет қаралды 84,718
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.
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltrain...
📚 Excel Books & Tech Gear ➜ www.amazon.com...
⚙️ Tools: Screencasting ➜ techsmith.z6rj...
⚙️ Tools: Microsoft Office ➜ microsoft.msaf...
⚙️ Tools: TubeBuddy ➜ www.tubebuddy....
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to www.buymeacoff...
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~