How to Separate Names in Microsoft Excel

Share this & earn $10
Kevin Stratvert
Published at : 11 Jan 2021
8655 views
387
2

Easily separate First Name from Last Name in Excel, including if there are middle names, and with no formulas. Simply use tables and fill series to separate the first name from the last name. In this video, I use the latest version of Excel that comes with Office 365.

Watch more Excel tutorial videos: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

As full disclosure, I work at Microsoft as a full-time employee.
excelofficemicrosoft

The Vendor Client relationship - in real world situations

The Vendor Client relationship - in real world situations

Fortnite Dance Battle Of All Golden Skins

Fortnite Dance Battle Of All Golden Skins

How to Examine the Groin by Per Holmich

How to Examine the Groin by Per Holmich

If A Ghost Possessed Someone In 2020

If A Ghost Possessed Someone In 2020

Why cross-border e-commerce is tougher than most business owners think

Why cross-border e-commerce is tougher than most business owners think

President Trump refuses to concede

President Trump refuses to concede

VLOG TIME!!! quite a lot of days lol | Sophia and Cinzia

VLOG TIME!!! quite a lot of days lol | Sophia and Cinzia

Stretches to Alleviate Neck, Back and Shoulder Pain

Stretches to Alleviate Neck, Back and Shoulder Pain

How to Use Washing Machines | Cleanipedia

How to Use Washing Machines | Cleanipedia

How the human brain is different from other animal brains

How the human brain is different from other animal brains

My marathon experience 😭 How I went from not being able to run TO running the LONDON MARATHON!!

My marathon experience 😭 How I went from not being able to run TO running the LONDON MARATHON!!

My best friend came to visit me for my birthday and I started a NEW JOB

My best friend came to visit me for my birthday and I started a NEW JOB

Sia - Quit ft. Ariana Grande (Lyrics)

Sia - Quit ft. Ariana Grande (Lyrics)

Tom Bilyeu Motivation | Motivational Speeches Compilation | BUILD YOUR SELF WORTH

Tom Bilyeu Motivation | Motivational Speeches Compilation | BUILD YOUR SELF WORTH

Challenger Convertible is PRICEY!!!

Challenger Convertible is PRICEY!!!

A College Student with Down Syndrome and his Autistic Roommate

A College Student with Down Syndrome and his Autistic Roommate

Tyga- Stimulated official video

Tyga- Stimulated official video

Camila Cabello on Struggling to Call Shawn Mendes "Baby" and Stealing from Prince William

Camila Cabello on Struggling to Call Shawn Mendes "Baby" and Stealing from Prince William

Ebone HoodRich Ft. Lil Mister - A Lot Of Money [Alotta Money]

Ebone HoodRich Ft. Lil Mister - A Lot Of Money [Alotta Money]

15 Hottest Women In The World 2020

15 Hottest Women In The World 2020

formulation of suspensions

formulation of suspensions

#BlackChicagoBeLikePart74🚘🤦🏿‍♂️FT. Skinbone & Tookey❤️

#BlackChicagoBeLikePart74🚘🤦🏿‍♂️FT. Skinbone & Tookey❤️

Pre-Authorization Of Shares in Zerodha / How to Authorized of Holding Shares before Selling

Pre-Authorization Of Shares in Zerodha / How to Authorized of Holding Shares before Selling

I tested positive.... :(

I tested positive.... :(

Back to School (1986) - Professor Terguson Loses It Scene (5/12) | Movieclips

Back to School (1986) - Professor Terguson Loses It Scene (5/12) | Movieclips

civil procedure code / section 1 and 2 / bare act /English

civil procedure code / section 1 and 2 / bare act /English

Judicious Mone Kore Amay Vaidik Rakhna

Judicious Mone Kore Amay Vaidik Rakhna

Ailing Fidel Castro Gives Rare Speech

Ailing Fidel Castro Gives Rare Speech

CNET Top 5 - Technologies that seem to never die

CNET Top 5 - Technologies that seem to never die

Vuplast d.o.o. - Supporting hospitals in need of equipment

Vuplast d.o.o. - Supporting hospitals in need of equipment

One of the coolest winning rides you'll see! 😎

One of the coolest winning rides you'll see! 😎

TOURING a 6.900.000€ EXTRAORDINARY MANSION with 17 bedrooms in Paseo del Parque, Sotogrande

TOURING a 6.900.000€ EXTRAORDINARY MANSION with 17 bedrooms in Paseo del Parque, Sotogrande

What Only Fans is Actually Like! (6 Months in)

What Only Fans is Actually Like! (6 Months in)

Dance on: Ghar More Pardesiya | Kalank

Dance on: Ghar More Pardesiya | Kalank

Popular music from underrated artists!

Popular music from underrated artists!

Millionaire: Most Exciting Show Ever, Shiva Oswal makes history, becoming youngest to win $250,000!

Millionaire: Most Exciting Show Ever, Shiva Oswal makes history, becoming youngest to win $250,000!

Conference Activities - How to energise your delegates

Conference Activities - How to energise your delegates

Pediatric Hematology

Pediatric Hematology

30+ REPAIR TIPS you will adore

30+ REPAIR TIPS you will adore

LOVE Life&Dance - Workshops 7&8 for personal development of youngsters

LOVE Life&Dance - Workshops 7&8 for personal development of youngsters

very nearly

very nearly

Cognitive Theory - Give It Some Thought

Cognitive Theory - Give It Some Thought

► Highly trained assassin goes back in time to fight WW2 alongside the Germans

► Highly trained assassin goes back in time to fight WW2 alongside the Germans

French Fries Tier List

French Fries Tier List

How To Do The Rockabilly Stroll

How To Do The Rockabilly Stroll

The Consequences of Riding The CC 🐓🎠(3000 Subscriber Special)

The Consequences of Riding The CC 🐓🎠(3000 Subscriber Special)

Opeth - A Fair Judgement | Live in Sydney | Moshcam

Opeth - A Fair Judgement | Live in Sydney | Moshcam

Lamelo Ball - "Psycho" (Lithuania 2018 Mix) - HD

Lamelo Ball - "Psycho" (Lithuania 2018 Mix) - HD

Russian Folk Song - Talyanochka (Тальяночка)

Russian Folk Song - Talyanochka (Тальяночка)