GetBold Function

GETBOLD() Description

The GETBOLD() function is designed to return text fragments from a cell that have "bold" (Bold) formatting.

Main Characteristics of GETBOLD Function

Syntax:

=GETBOLD(Cell; [Entry])

Parameters:

• Cell: Reference to the cell from which it is necessary to extract bold text.
• [Entry]: (Optional) Sequence number of the entry of the required part of the text. It can also have a negative value, which will mean searching for the entry from the end of the string. At a value of 0 - returns all entries.

Usage Example

The GETBOLD() function is useful when different font styles are mixed in one cell, and you need to isolate only emphasized (bold) words. Excel (Calc) will automatically find and return these fragments:

=GETBOLD(Cell; Entry)

We will have the following result:

In this example, the following values are used:

• Cell: A3 - Cell with text where part of the words are highlighted in bold.
• Entry: D2 - Display the last entry (-1).

Download extension

You can use the GETBOLD() function by installing the YLC Utilities extension.

After that, this function will be available in all files that will be opened in Excel (LibreOffice Calc).