This quick tutorial explains the steps required to Count Words in LibreOffice Calc Cell. There are no direct features available in LibreOffice that can help you to count words. In the early article, I explained how to count characters in LibreOffice Calc.…

This tutorial explains the basics of how you can find the characters position in LibreOffice Calc. While processing data, it is often required to find a particular position of a character in a string. And you may want to repeat the search in multiple cells…

A simple tutorial which explains various ways to remove spaces using formula, find/replace methods using functions.

A simple guide that explains how you can compare two columns in LibreOffice Calc sheet with examples.

This article explains two essential functions of REPLACE and SUBSTITUTE in LibreOffice Calc. Often, you need to use the SUBSTITUTE function to replace a portion of a text in a cell. It can be in a single cell or a range of cells. So, to do that, you need…

An article demonstrating how to copy and paste format only in LibreOffice Calc and Writer, including step-by-step process and examples.

A tutorial on how you can fix the common problem "Can't Open LibreOffice" which is seen in Windows and Linux

A tutorial on how to change the default line spacing in LibreOffice Writer with details about additional and custom spacing options.

This article explains how you can install and use thesaurus in LibreOffice (Writer, Impress, Calc, etc) for various languages.

Examples of TEXT function in LibreOffice Calc which is one of the powerfull function available used to format numbers.

A tutorial on how to find End of Line characters (CR or LF) , new lines, line breaks in LibreOffice Writer document.

A tutorial on how you can add nice Sparklines in LibreOffice Calc cells and additional customizations to configure it.

Learn to concatenate strings in LibreOffice Calc cells using various formula and examples and be a champ in Calc.

This article contains different ways to find substring in LibreOffice Calc program so that you can extract part of values from cells.

A beginner's guide demonstrating various lookup and reference functions in LibreOffice Calc program with easy to understand examples.

A novice user guide on VLOOKUP function in LibreOffice Calc spreadsheet program with examples and things you need to know.

What is the difference between the comma and semicolon separator in the LibreOffice formula in a spreadsheet? Learn which one to use.

What is LibreOffice Base database program? How to install and use it? A beginner's getting started guide with screenshots.