Auxiliary menu for Microsoft Excel (28.10.2025)

Auxiliary menu for Microsoft Excel (28.10.2025)

New in ver. 28.10.2025

- special formatting in cells ('* #,##0.00;* -#,##0.00;" – ";@* ').

Examples:

Before	After (example 1)	or	After (example 2)

New in ver. 06.09.2025:

- new mathematical and accounting functions (VALWITHOUTVATFROMVAT and VALWITHOUTVATFROMVATP);
- guide review.

Formula applied:

$$\frac{\frac{\text{VAT value}\times \left(100+\text{VAT}\right)}{\text{VAT}}}{(1+\frac{\text{VAT}}{100})}=\frac{\frac{300\times 121}{21}}{(1+\frac{21}{100})}=\mathrm{1,428.57}$$

Standard formula:

$$\frac{\frac{(\text{VAT value}\times 100)}{\text{VAT}}}{}=\frac{\frac{(300\times 100)}{21}}{}=\mathrm{1.428,57}$$

New in ver. 28.08.2025:

- SUMTEXTSPLIT function – sums the values separated by a value separator in a cell.

SUMTEXTSPLIT function	Combination of SUM and TEXTSPLIT functions

New in ver. 07.07.2025:

- optimization and corrections to Import and convert documents to Excel (documents in PDF, DOC, DOCX and DOCM formats).

Original file, in PDF format		File imported into Excel

or

Original file, in Word format (DOCX)		File imported into Excel

New in version 23.03.2025:

- change color and formatting, as appropriate, for text fragments in cells;
- IMAGE_UDF function – imports images from URL;

The IMAGE_UDF function may have some functionality limitations in Microsoft Excel 2010.

- change of menu appearance;
- information about the menu;
- improvement Calendar date correction;
- corrections and improvements to Number to text conversion;
- improvement Change to upper/lower case;
- improvement Measurement unit correction;
- guide revision.

New in version 20.01.2025:

- restoring the download link for this kit;
- changing the appearance of the menu.

New in version 27.11.2024:

- a new function; the REMOVEDIACRITICS function deletes the diacritics from the reference cell. 

This function applies to characters with diacritics related to the languages: Romanian (with old and new diacritics), Polish, Slovak, Slovenian, Serbian, Croatian, German, Turkish and French.

Auxiliary menu for Microsoft Excel (28.10.2025) includes:
- conversion of tabular text file, CSV or TXT format, into Excel file, XLSX format;
- accessing and executing the "Conversion TXT, CSV -> XLSX" command also from the File-Backstage menu, without the need to open a new empty file beforehand;
- correcting the calendar date after importing data, in CSV/TXT/XLS(X) format, from programs that use the PostgreSQL database;
- importing and converting PDF, DOC, DOCX and DOCM documents into Excel — XLSX files;
- converting any number into text format in the selected cells/columns;
- change text from the selected cells to uppercase and/or lowercase letters;
- correction of measurement units from "M2" to "m²", "M3" to "m³", "MP" to "m²", "MC" to "m³", etc. in selected cells/columns;
- conversion of formulas into value / text / calendar date / percentage;
- mathematical and accounting functions (CALCULPEN, CODECOLOR, CODEHEXCOLOR, CONVNRLETTERSEN, CONVNRLETTERSRO, COUNTCOLOR, EXTRACTDATE, EXTRACTWORD, IMAGE_UDF, RANKUNIQUE, REMOVEDIACRITICS, SUMCOLOR, SUMCOLORVLT, SUMTEXTSPLIT, UNIQUECOLOR, UNIQUESORT, VALDISC, VALDISCP, VALDISCPTOVAL, VALDISCTOVAL, VALVAT, VALVATP, VALWITHDISC, VALWITHDISCP, VALWITHDISCPTOVAL, VALWITHDISCTOVAL, VALWITHOUTDISC, VALWITHOUTDISCP, VALWITHOUTDISCPTOVAL, VALWITHOUTDISCTOVAL, VALWITHOUTVAT, VALWITHOUTVATP, VALWITHOUTVATFROMVAT, VALWITHOUTVATFROMVATP, VALWITHVAT, VALWITHVATP, VALWITHVATFROMVAT, VALWITHVATFROMVATP);
- guide for mathematical and accounting functions (CALCULPEN, CODECOLOR, CODEHEXCOLOR, CONVNRLETTERSEN, CONVNRLETTERSRO, COUNTCOLOR, EXTRACTDATE, EXTRACTWORD, IMAGE_UDF, RANKUNIQUE, REMOVEDIACRITICS, SUMCOLOR, SUMCOLORVLT, SUMTEXTSPLIT, UNIQUECOLOR, UNIQUESORT, VALDISC, VALDISCP, VALDISCPTOVAL, VALDISCTOVAL, VALVAT, VALVATP, VALWITHDISC, VALWITHDISCP, VALWITHDISCPTOVAL, VALWITHDISCTOVAL, VALWITHOUTDISC, VALWITHOUTDISCP, VALWITHOUTDISCPTOVAL, VALWITHOUTDISCTOVAL, VALWITHOUTVAT, VALWITHOUTVATP, VALWITHOUTVATFROMVAT, VALWITHOUTVATFROMVATP, VALWITHVAT, VALWITHVATP, VALWITHVATFROMVAT, VALWITHVATFROMVATP); 

The guide is accessed in the menu Tools > Formulas > Functions.

- positioning, moving or/and multiplying any object according to parameters and coordinates (shape , image, chart);
- change color and formatting, as appropriate, for text fragments in cells;
- special formatting in cells ('* #,##0.00;* -#,##0.00;" – ";@* ');
- sending the files in the work, via e-mails, with the help of Microsoft Outlook (Classic), in PDF or original formats. 

After installing the  Auxiliary Menu kit for Microsoft Excel (28.10.2025).exe, in  Microsoft Excel 20xx a new group of commands named "Tools"  will appear in  the command ribbon, as shown in the image above down.

Auxiliary Menu for Microsoft Excel is compatible with Microsoft Excel 2010 / 2013 / 2016 / 2019 / 2021 / 2024 / 365.

The kit is virus free and can be downloaded by clicking on the image below or here:

Archive password: 654321.

(The article continues below. ↓)

Examples

Figure 1 – Extracting benchmarks uniquely and sorting them

Figure 2 – Converting numerical value to monetary value in letters

Figure 3 – Value without VAT, Value with VAT and VAT

Figure 4 – Discount

Figure 5 - Summation of cells according to their color

Figure 6 - Counting cells according to their color

Figure 7 - Extracting one or more words from a text in the cell

Figure 8 - Extracting the calendar date from a cell text

Figure 9 - Volatile summation based on background color with conditional formatting

Figure 10 - Volatile summation based on background color with conditional formatting and based on a criterion

Figure 11 - Example of positioning and sizing the object according to the desired range of cells

Figure 12 - Descending numbering with RANKUNIQUE vs RANK.EQ

Figure 13 - Calculation of the penalty for late payment of an invoice based on the reference interest rate
for the respective period

All articles on this site can be distributed with acknowledgement of the source, including a link to the article or site.

Other topics on the same topic:
- Meniu auxiliar pentru Microsoft Excel.