• UA
• RU
• EN
• ⯈
  ES JA DE HI AR CN PT FR IT KO PL RO TR

Complete list of utilities included in the "YLC_Utilities.xlam" extension

1) Text

• Change text to UPPER CASE Capitalize all words
• Change text to lowercase Writing all words in lowercase
• Start text with a capital letter Capitalize the first word and lowercase the rest of the words
• Start all words with a capital letter. Change the text so that every word starts with a capital letter
• First character capitalized Change the first character in text to uppercase, but leave the remaining characters unchanged.
• Other register options Sentence case, title case, Pascal case, camel case, snake case, kebab case, and space case
• Delete all letters in text Text cleaning by removing all letters in the text
• Remove all numbers in text Clean text by removing all numbers in the text
• Remove trailing spaces in text Remove all spaces from the beginning and end of text
• Remove excess spaces in text Remove all spaces at the beginning and end of text, as well as excess spaces in the middle of text
• Remove initial characters Delete a certain number of characters at the beginning of text
• Remove trailing characters Removing a certain number of characters at the end of text
• Delete text after a certain number of characters Delete all text starting from a specific position
• Get the word by the specified separators Splitting text into parts by many delimiters at once and getting the required element by occurrence number
• Highlight Latin letters in text Mark Latin letters in red
• Highlight Cyrillic letters in text Mark the Cyrillic letters in red
• Google Translate Translate text using Google Translate

2) Number

• Apply additional calculations to selected cells Quickly insert additional calculations into a formula
• Change the formulas to their calculated values Replace the formula in selected cells with their calculated values
• Converting unrecognized numbers (text?) to numbers Changes numbers that LO Calc does not recognize and that are displayed as text to true numeric numbers
• Change the value to text (by adding ' in front) Changes all numbers in selected cells to text values.
• Fill cells with their formatted value Replaces the contents of selected cells with their formatted value
• Change negative numbers to positive numbers and vice versa Changes positive numbers to negative and negative numbers to positive
• Move the minus sign from the end to the beginning (e.g. 47- to -47) Fixes negative numbers that have a minus sign at the end
• Use a significant number of decimal places Rounds or formats numbers in cells to display non-zero digits after the decimal point/period
• Writing a number or amount in words Converts numbers or sums written in numbers to text in English

3) Date

• Date conversion/recognition Converts unrecognized dates in selected cells

4) Range

• Mark unique values Mark cells with unique values in yellow
• Mark different values Mark cells with different values in yellow
• Mark duplicates Mark cells with repetitions with different colors
• Mark outliers Highlight cells in yellow that are a repeat of previous values in the selected range
• Reorganizing the table Pivoting a table (unpivo) from cross-pivot to flat

5) Formula

• Convert formula to text Save cell formula as text value
• Convert text to formula Save cell value as formula
• Display "blank" if error Wrapping a cell formula in the IFERROR function with an alternative value of "empty"
• Display "0" if error Wrapping a cell formula in the IFERROR function with an alternative value of "0"
• Show/hide formulas Switch between formulas and values for all cells
• Insert YLC function Insert function from set "YLC Utilities"

6) Comment

• Copy value to comment Copying a cell result to a comment
• Copy formula to comment Copying a cell formula into a comment
• Copy comment to cell Copying a comment into a cell formula
• Move comment to cell Move a comment into a cell formula while simultaneously deleting it
• Show/hide comments Show/hide all comments

7) Sheet

• Add sheets Insert new sheets into a workbook using names from selected cells
• Sort sheets Sort all sheets alphabetically (ascending or descending)
• Save sheets as books Save selected sheets to separate files

8) Styles for tables

• Change table style Formatting the table according to the selected color scheme (black, blue, red, green, purple, navy, orange)

9) External data

• Official currency exchange rates Obtaining currency rates from the official websites of national banks of countries