Extract First, Last & Middle Name Excel Power Query

Doug H
Doug H
6.7 هزار بار بازدید - 2 سال پیش - You’ve got names in a
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  ➜ https://goo.gl/wN3c3p

🏫 Excel Training ➜ https://www.exceltraining101.com/p/tr...

📚 Excel Books & Tech Gear  ➜ https://www.amazon.com/shop/dough

⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53

⚙️ Tools: Microsoft Office ➜  https://microsoft.msafflnk.net/rKL0G

⚙️  Tools: TubeBuddy ➜  https://www.tubebuddy.com/et101

📝 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
https://www.buymeacoffee.com/dough

#excel
#msexcel
#doughexcel

~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
Convert Table in a PDF File to Excel
~-~~-~~~-~~-~
2 سال پیش در تاریخ 1401/07/27 منتشر شده است.
6,718 بـار بازدید شده
... بیشتر