Extract First, Last & Middle Name Excel Power Query

No video

Extract First, Last & Middle Name Excel Power Query

Рет қаралды 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...
~-~~-~~~-~~-~

Пікірлер: 18

@CAKimberlyLewis 2 ай бұрын

👏VERY CREATIVE SOLUTION! Thank you!

@DougHExcel 2 ай бұрын

Thank you! Cheers!

@aurt Ай бұрын

best tutorial for this purpose. Thank you.

@DougHExcel Ай бұрын

Glad you think so!

@abelstauber201 11 ай бұрын

Brilliant!!! Thank you very much!!!

@DougHExcel 11 ай бұрын

Hi ABEL STAUBER, you're welcome!

@jeanyuan9852 Жыл бұрын

Doug, your video is better than the best

@DougHExcel Жыл бұрын

Hi Jean Yuan, thanks for the kind words! 😊

@patrickschardt7724 Жыл бұрын

How do you account for first or last names with a space in them, like Lee Anne or Van Der Loo

@DougHExcel Жыл бұрын

unfortunately unless there a character to "indicate" the separate words of the last names are part of the last name, it's a manual process to address those. A helper column that counts the number of spaces in the full name can help flag those records for review.

@707ranju Жыл бұрын

How it work if the name contain only first name?

@LaloinLondon Жыл бұрын

How can you know if there is a double-barrelled surname?

@DougHExcel Жыл бұрын

those are the exceptions that might not work depending on hyphenation. If it's hyphenate it'll work, unhyphenated...ugh...it'll be something where you'd need to know to tease out these exceptions manually.