Convert text to formula

Formula > Convert text into formula

This tool converts the text value of a cell into its formula.

This way, you can dynamically create formula text and then convert it into a "real" cell formula.

Screenshot

Before conversion:

After conversion:

Launching this tool

Click YLC Utilities > Formula > Convert text into formula :

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. LO Calc , the amount of data you work with, and how often you use this tool.

Download extension

You can use the utility Convert text into formula by installing the extension YLC Utilities .

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