Delete everything after the specified number of characters

Text > Delete all after a given number of characters

This utility removes all characters that come after a specified length in selected cells.

The utility works with both numbers and text. Cells with formulas will be skipped.

To remove characters in cells with formulas, you must first convert the formulas to values.

You can, for example, use it to quickly remove everything after the first 4 characters in your data range.

Screenshot

Running this tool

Click YLC Utilities > Text > Delete all after a given number of characters :

This is a faster alternative than using a temporary column and the =LEFT() function.

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 Delete all after a given number of characters by installing the extension YLC Utilities .

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