How to Extract First Name in Excel (2 Helpful Ways)
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:
• Creating Fillable Forms in Microsoft ...
__________
CONNECT WITH ME 📎
Visit my website: https://www.sharonsmithhr.com for more information, tools and resources.
LinkedIn: / sharonsmithhr
Twitter: / sharonsmithhr
Instagram: / sharonsmithlearning
__________
GEAR
🎙 Blue Yeti USB Microphone: https://amzn.to/2W4SbzV (Great for recording professional sounding audio for your videos!)
🖱 Silent Mouse: https://amzn.to/3pxpc25 (This is a really cool mouse!)
🎥 Screen Recording Software: https://techsmith.z6rjha.net/NZG5b
📗 Green Screen: https://amzn.to/2DnHsY2
📸 Camera: https://amzn.to/39KvpQA
🔌 Live Stream Tool: https://amzn.to/2VFJyID (Turns your DSLR into a top notch webcam)
RESOURCES
✏️ JotForm: https://www.jotform.com/pricing/?utm_...
📑 Wondershare PDFelement (PDF Editor): https://bit.ly/31QEkA8
💻 PresenterMedia: https://shareasale.com/r.cfm?b=417324...
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: https://www.etsy.com/listing/87584666...
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: https://www.paypal.com/cgi-bin/webscr.... 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 https://mailchi.mp/6a0859ea0844/sharo... 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: • Jotform Tutorials
➤Creating Fillable Forms: • How To Create A Fillable Form In Micr...
➤PowerPoint Tutorials for HR: • PowerPoint Tutorials
➤ Excel Tutorials for HR: • Microsoft Excel Tutorials
➤ Excel Quickies (Around 2 Minutes): • Excel Tips & Tricks
➤ Word Tutorials for HR: • Microsoft Word Tutorials
