How To Use TEXTAFTER Function in Excel To Extract Text After a Specific Character Simplified
Formulae
=TEXTAFTER(B2,"/",-1)
The above TEXTAFTER Function is to copy the last character after the "/" slash symbol.
In this video, we'll explore the powerful TEXTAFTER function in Excel, a game-changer for anyone looking to extract text after a specific character in their data. Whether you're working with names, addresses, or any other text strings, this function simplifies the process, saving you time and effort.