Get the word by the specified separators

Text > Get word by delimiters

This utility returns any word in the text by a given set of separators in the selected cells.

You can also use the function GETWORD() .

Screenshot

Launch this tool

Click YLC Utilities > Text > Get word by delimiters :

How much time will it save?

Using this tool, you are guaranteed to save time and effort. However, the actual time savings depends on how often you use LibreOffice Calc, the amount of data you work with, and how often you use the tool.

Download

If you don't already have YLC Utilities, you can download the free version "YouLibreCalc.oxt" or the full-featured version "YLC_Utilities.oxt" .