Many times you are likely to get confused with the function argument separator in Excel, this very important element that can cause so many problems. Therefore, we have decided to inform you correctly so that this is no longer a problem when working when the argument separator is not configured correctly in any Microsoft Excel document.
What is actually the function argument separator in Excel?
The understanding problem generated by this separator is given by the language in which Excel is handled. Computers that are configured in Spanish, usually have a default symbol, while in English and other languages another is used, if not, you may be interested in knowing how to change the language to Microsoft Excel.
But this is not a big problem, because many of the functions that we create or copy from the internet, only need this symbol to be changed. The great dilemma has been generated between the comma (,) and the semicolon (;), each one belonging to a language in Excel.
The default function argument separator in Excel is the semicolon (;). Everything is the opposite when it comes to English, who use the comma (,) as a separator and both are really correct.
This confusion has caused many people to think that they are doing wrong in a function; the worst thing is that the functions can work just by changing the separator, something that leaves many bad, especially for being such a small detail.
Something very interesting is that the Latin American continent uses the comma (,), but those computers with Spanish software default the semicolon (;). But in the end this is not something that difficult to solve, with some modifications, this will be resolved and the doubt will disappear forever.
How to customize function argument separator in Excel?
The process to determine the separator in a personalized way is quite simple, you must follow the steps in detail to achieve it without problems. Keep in mind that you must enter the Excel settings, so avoid doing steps that are not indicated.
To begin, enter Excel, open a blank document, just to configure the separator, you must go to the “ File” tab. While there, look at the end of the menu, the entry “Options”, click on it to open the Excel settings.
While there, you must look for the “Advanced” tab, this is where you will configure the separator, you will need to locate the option ” Use system separators”. Once you find it, it will be necessary to uncheck it, this will activate the option “Decimal separator”, in its box, you must place a comma (,) or a semicolon (;). Once this is done, you will have managed to change the separator, you just have to press “OK” and that’s it, everything will be solved. Remember the mechanism well in case you need to return the separator to the symbol it had previously.
This change can be quite useful in case you change country or want to publish a function on a page, making it understandable. Keep in mind that if your computer can change languages, it is likely that the separator will also change, consider checking this before starting to work and it is also possible that the size of your Excel file is very heavy and you need to reduce the size of the Microsoft Excel file.
Can other symbols be used as function argument separator in Excel?
The truth is that when customizing the separator, this allows any symbol that is preferred to be used, but this is not recommended. Normally, each symbol has a predetermined function that can be altered if it is used in a different way, for example when copying some strange character such as emojis for Excel.
It is really very difficult to determine what would happen to the rest of the symbology if an element other than the semicolon (;) or comma (,) is used. Therefore, the most advisable thing is to stick to these two separators that, although they generate doubts in many, are the popularly used ones.