Microsoft Office
Eliminating diacritics
There are some situations when we need to use, in MS Office applications (eg Excel), certain words without…
The lowest and highest value simultaneously formatted
If we have several intervals where we want to highlight, through conditional formatting, the lowest and the highest…
Remove own styles at once
Sometimes, if we have to format various retrieved documents, we may realize that the phrase “better to redo…
Letter spacing button
To be able to use it in all Word files, you can work directly in the normal.dotm template….
Worksheet dynamization
I appreciate some features that I have used in specific applications where, for example, the width of a…
Decimal Truncation
In MS Access, there may be situations, more rarely, when you don’t want to round some numerical values…
Automatic rounding for a range of cells
If it is desired that, in a sheet, numerical values be formatted and displayed by rounding with a…
Proper Text in MS Access
Excel has the default function Proper, which allows the ability to display only the first letter of a…
Calculating seniority up to a certain year
Let’s assume that knowing the date of employment, we would be interested in the seniority of employees (in…
Multiselect filtering in the form, using ListBox
Single Form To achieve the desire in the title it is required a table, a form and a…