Microsoft Excel Tutorial - How to split up a single Name cell into First Name and Last Name cells

Channel:
Australia Magic Monk
Subscribers:
64,099
Published on ● Video Link: https://www.youtube.com/watch?v=hJ-004ze7Rs


Category:
Tutorial
Duration: 11:49
150 views
4

If you work with data you will come across this sometime in your career I'm sure. Someone has decided for a system to export data with names of people in one single cell, but you want to split it into two separate cells. How is this possible when every name has a different number of characters? The magic monk shows you how.



Other Videos By Magic Monk


2020-04-0330 day yoga challenge day 7
2020-04-0230 Day yoga challenge day 6
2020-04-0130 Day Yoga Challenge Day 5
2020-03-3130 Day Yoga Challenge Day 4
2020-03-3030 Day Yoga Challenge Day 3
2020-03-2830 Day Yoga Challenge Day 2
2020-03-27Join Magic Monk's 30-day Yoga Challenge - Day 1
2020-03-26Bouldering @ urban climb Brisbane 2020-03-20
2020-03-25Python Lesson 1 - Print to Screen, Numerical Operations
2020-03-19Microsoft Outlook Folders panel disappeared
2020-03-16Microsoft Excel Tutorial - How to split up a single Name cell into First Name and Last Name cells
2020-03-13Samsung Galaxy S10e part 7 - Unlock phone with facial recognition
2020-03-10Samsung Galaxy S10e part 6 - How to enable speakerphone automatically when calling
2020-03-07Samsung Galaxy S10e part 5 - Make a call while phone is locked via Google Assitant (hands free)
2020-03-04Samsung Galaxy S10e part 4 - Voice activate Google Assistant while phone is locked
2020-03-01Super cheap Air Fryer under $50 USD! Anko AF606 Demonstration
2020-02-27HP Deskjet 3630 part 3 - Set up printing / scanning on new phone
2020-02-24HP Deskjet 3630 part 2 - Scanning directly to your phone ($15 wireless printer scanner)
2020-02-21$15 Wi-Fi Printer Scanner HP Deskjet 3630 - Unboxing, Set up, Print from Phone
2020-02-18Witcher 3 - Where to find drowner brain for On Death's Bed quest
2020-02-15Microsoft Excel Keyboard Shortcuts for Highlighting / Data Selection (Office 365 ProPlus)