How to Split Full Name into Last Name in Excel and Google Sheets
🌟🌟NEW FREE ENGLISH QUIZZES🌟🌟
https://whizbusters.teachable.com/p/e...
💰2000 questions
💰Basic, Intermediate, Advanced Level
💰Word Quizzes + Sentence Quizzes
💰Video Solutions for each answer
💰No login required
💰Enhanced your English vocabulary anywhere and anytime
***************************************************************************************************** Quickly learn how to extract the LAST NAME after a SPACE or extract TEXT AFTER a space, symbol or character in Excel and Google Sheets.
In this video I will show you how to extract the text AFTER a space with 2 functions
1 - The MID Function • MID Functions with examples to extract cha...
2 - The FIND Function • FIND a character or string from another st...
With the MID function we extract text from the middle of a string. And with the FIND function we can get a number that represents the position of the first character of the text which we want to extract.
And later in the video you will get a formula you can save,
So you can use this formula whenever you have to extract text before a space, symbol or character.
Time Stamps
00:00:00 Objective
00:00:39 Example of extracting the LAST NAME from a cell before a space. Use 2 functions MID function and FIND function to extract the first name
00:00:51 Example of extracting the LAST NAME with the MID function ONLY
00:03:26 Use the FIND Function to find the position of the space
00:04:32 Relationship between the result from the FIND function (to find the position of a space) and the number of characters in the text before a space
00:05:06 Use FIND function within the MID function as a parameter to calculate the number of characters in the FIRST NAME
00:05:59 FORMULA to extract FIRST NAME before a space. It can be used to extract text before a space, symbol or character.
INDEX function: • EXTRACT values and arrays from a table usi...
MATCH function: • MATCH Function explained with examples in ...
VLOOKUP function: • Master VLOOKUP explained with examples in ...
FUNCTIONS: • Playlist
PROBLEMS: • Playlist
ORGANIZE DATE: • Playlist
MID Function Support Docs: https://support.google.com/docs/answe...
FIND Function Support Docs: https://support.google.com/docs/answe...
Let’s connect on social:
Instagram: /
LinkedIn: / whizbusters
Twitter: / whizbusters
Facebook: / whizbusters
www.whizbusters.com
#GoogleSheets #MsExcel #englishlanguage #worddefinition #learnenglish #englishvocabulary #pronunciationguide #languagelearning