Delete everything after the specified number of characters

Text > Delete all after a given number of characters

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

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

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

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

Screenshot

Launch 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 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" .