How Do I Pull Just Last Names In Excel?
Need to extract last names from full names in Excel—without manual edits or formulas that break? Learn how TEXTAFTER makes it effortless.
This Excel video teaches you how to use a function called TEXTAFTER to work with text data in spreadsheets.
Imagine you have a list of full names, but you only want to extract and create a new list containing just the last names.
TEXTAFTER helps you do that. It's like a magical tool that allows you to pick out text from a certain point in a sentence.
For instance, if you had "John Doe" in one cell, TEXTAFTER can help you get just "Doe" by specifying that you want the text after the space.
You can even use it to grab text after specific characters or spaces. It's like telling Excel to find a certain character, like a comma, and give you what comes after it.
But be careful, if Excel can't find what you're asking for, it might give you an error message or an empty space.
So, this video helps you use TEXTAFTER in different ways to make your Excel tasks easier.
EXCEL PRIMED RECOMMENDED COURSES
**Excel Essentials - The A-Z Guide for Advanced Users:
https://excelprimed.com/courses/excel...
**Excel Essentials - The A-Z Guide for Beginners Level I:
https://excelprimed.com/courses/excel...
**Excel Essentials - The A-Z Guide for Beginners Level II:
https://excelprimed.com/courses/excel...
**Excel Essentials - The A-Z Guide for Intermediate Users:
https://excelprimed.com/courses/excel...
**Excel Formulas - Advanced Level I:
https://excelprimed.com/courses/excel...
**Excel Formulas - Advanced Level II:
https://excelprimed.com/courses/excel...
**Excel Formulas - Beginners Level I:
https://excelprimed.com/courses/excel...
**Excel Formulas - Beginners Level II:
https://excelprimed.com/courses/excel...
**Excel Formulas - Intermediate Level I:
https://excelprimed.com/courses/excel...
**Excel Formulas - Intermediate Level II:
https://excelprimed.com/courses/excel...
**Excel Data & Text Manipulation - Advanced Users:
https://excelprimed.com/courses/excel...
**Excel Data & Text Manipulation - Beginners:
https://excelprimed.com/courses/excel...
**Excel Data & Text Manipulation - Intermediate Users:
https://excelprimed.com/courses/excel...