Two methods of removing duplicates from LIbreOffice Calc sheet which includes an easy and a comparatively difficult method.

This beginner’s guide explains how you can find the weekday, workday in LibreOffice Calc. LibreOffice Calc has dedicated functions that you can use to find out the weekday, the number of weekdays, etc. Using these in the formula and combining them, you can…

Learn how you can split cell content into the multiple columns in LibreOffice and OpenOffice using examples.

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.