TOP

Remove leading characters

YLC Utilities logo

Text > Delete number of leading characters

This utility removes a specified number of characters from the beginning of the text in the 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 the first three characters in all selected cells.


Screenshot

Text > Delete number of leading characters

Launch this tool

Click YLC Utilities > Text > Delete number of leading characters :

Text › Remove leading characters

Do you recognize any of these situations?

Decision

Just select the cells and then choose the following tool from the LO Calc menu:

YLC Utilities » Text » Delete number of leading characters

This is a faster alternative than using a temporary column and a combination of the =LEFT(), =MID(), =RIGHT(), and =LEN() functions.

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


Additional keywords for this tool:
remove characters at the beginning, remove unnecessary characters from the cell, trim the text, discard the first letters, numbers