Рет қаралды 6,898
You’ve got names in a column cell and you want to separate first, middle and last names. Easy to do if ALL the values were the simple first…middle… and last name. But what if some didn’t have middle names? What if some had two or three middle names?
Easy if it was like 5 to 10 names. 20 names…not that easy...2000 names? Much harder to do. But if you’ve got power query, it’ll only take under 5 minutes to do. Plus once you set it up, you can do it over and over again.
🔔 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...
~-~~-~~~-~~-~