How to extract Middle Names with TEXTAFTER | Excel string functions - PART 6
As promised in Part 5, MM Technology introduces the TEXTAFTER function in this sixth installment. This modern tool is a game-changer for extracting text after a specific character.
Instead of nesting complex RIGHT, LEN, and FIND formulas, TEXTAFTER keeps your formulas concise and minimizes errors when handling inconsistent datasets.
Common use cases for TEXTAFTER:
📌 Extracting Last Names: Pull the name after the final space, regardless of the text length.
📌 Retrieving Suffixes & IDs: Get info following dashes (-), slashes (/), or dots (.) in product codes.
📌 System Info: Automatically separate domains from emails or file extensions from filenames.
Special Highlight: In this video, we will show you how to combine TEXTAFTER and TEXTBEFORE to solve one of the most common Excel challenges: Extracting the Middle Name from a Full Name.
Watch the Full Excel String Functions Playlist: https://zurl.co/yuadM
These functions are exclusively available in Microsoft 365. Check out more at: https://mmgroup.vn/microsoft-365/
_______________________
👍𝐒𝐔𝐁𝐒𝐂𝐑𝐈𝐁𝐄 𝐅𝐎𝐑 𝐌𝐎𝐑𝐄 𝐕𝐈𝐃𝐄𝐎𝐒: / @mmtechnology-vn
👍𝐑𝐀𝐓𝐄 𝐔𝐒 𝐎𝐍 𝐆𝐎𝐎𝐆𝐋𝐄: https://zurl.co/XSg1F
#exceltutorial #excelformulatypes #exel #microsoftpartner #excelforbeginners #tinhocvanphong #tuhocexcel #TEXTAFTER #Microsoft365 #HocExcel