Get the word by the specified separators

Text > Get word by delimiters

This utility returns any word in the text based on a given set of delimiters in the selected cells.

You can also use the function GETWORD() .

Screenshot

Running this tool

Click YLC Utilities > Text > Get word by delimiters :

How much time will this save?

Using this tool will definitely save you time and effort. However, the actual time savings will depend on how often you use it. Excel , the amount of data you work with, and how often you use this tool.

Download extension

You can use the utility Get word by delimiters by installing the extension YLC Utilities .

After that, this function will be available in all files that are opened in Excel .