The TRANSLATE function became part of Excel in July 2024, and recently we have another useful function that you can use to detect the language in which a text is written. It’s a new DETECTLANGUAGE function, and you can use it in conjunction with the TRANSLATE function.
When you enter decimal numbers, depending on the Region settings, you will use a decimal point or a comma. In most cases, this is done once, and we don’t deal with this topic anymore. However, it may happen in practice that you import data, most often from a CSS file, where different characters are used to separate decimals and groups than those you use by your local settings. In this case, use the NUMBERVALUE function…
Excel has recently made it easier to work with formulas that use arrays and constants – you no longer have to save them by pressing CTRL+SHIFT+ENTER! We can now use lists of values, given in curly brackets, as function arguments. This is great news, and the possibilities are manifold. In the following post, you will be able to see the real application of this feature…
The address of a cell in Excel is formed by combining the column label and the row number. For example, the address A1 indicates that it is a cell that is in the first row of column A. However, we can also assign an address in another way- by using the row number label and the column number. Thus, cell A1, in this alternative notation, would have the address R1C1. How to change the way the address is assigned and can it be of practical use?
It is common knowledge that the VLOOKUP function cannot return results that are “to the left” of a given range, and this problem is solved by XLOOKUP, which additionally allows you to search the range from the beginning or from the end. However, what if these functions need to return more results? To do this, you used to need to use array formulas, but today this is performed in a much easier way…