In this quick Excel tutorial, I'm going to show you two ways to extract the first name from a full name column in Excel. Extracting the first name from a list of full names can be incredibly useful when you're working with large datasets or need to organize information. I'll walk you through two methods, Text to Columns, and a special LEFT formula, ensuring you have all the tools you need to handle this task efficiently.

First, we'll explore the Text to Columns feature in Excel. This technique allows you to split the full name into separate columns based on a chosen delimiter. We'll demonstrate how to use this feature effectively and offer tips to ensure accurate results. Next, we'll cover the LEFT function, a versatile formula that allows you to extract a specified number of characters from the leftmost side of a cell. The syntax for the LEFT formula we use in this video is:
=LEFT(A1,FIND(" ",A1)-1)

#msexcel #exceltips #exceltipstricks

00:00 Extract First Name in Excel
00:08 Text to Columns in Excel
01:46 LEFT Function in Excel

📺 Check out my New YouTube Course! Create Fillable Forms in Microsoft Word:
[ Ссылка ]
__________
CONNECT WITH ME 📎
Visit my website: [ Ссылка ] for more information, tools and resources.
LinkedIn: [ Ссылка ]
Twitter: [ Ссылка ]
Instagram: [ Ссылка ]
__________
GEAR
🎙 Blue Yeti USB Microphone: [ Ссылка ] (Great for recording professional sounding audio for your videos!)
🖱 Silent Mouse: [ Ссылка ] (This is a really cool mouse!)
🎥 Screen Recording Software: [ Ссылка ]
📗 Green Screen: [ Ссылка ]
📸 Camera: [ Ссылка ]
🔌 Live Stream Tool: [ Ссылка ] (Turns your DSLR into a top notch webcam)

RESOURCES
✏️ JotForm: [ Ссылка ]
📑 Wondershare PDFelement (PDF Editor): [ Ссылка ]
💻 PresenterMedia: [ Ссылка ]=

Some links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel!
__________
TEMPLATES
Check out my helpful list of templates available for purchase: [ Ссылка ]
Thank you for supporting my channel!
(Scroll down for a link to my free resources)
__________
NOTE: If you found this content helpful, please consider donating to my channel from this PayPal link: [ Ссылка ]. Your donation, no matter what amount, is greatly appreciated and goes towards producing content that enhances your productivity and elevates your skills. Thanks for supporting this channel!
__________
FREE DOWNLOADS
✦ Visit [ Ссылка ] to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.
__________
PLAYLISTS:
➤ Jotform Tutorials: [ Ссылка ]

➤Creating Fillable Forms: [ Ссылка ]

➤PowerPoint Tutorials for HR: [ Ссылка ]

➤ Excel Tutorials for HR: [ Ссылка ]

➤ Excel Quickies (Around 2 Minutes): [ Ссылка ]

➤ Word Tutorials for HR: [ Ссылка ]

свернуть