Why does this Excel RIGHT function not work?

I am confused why this simple right() function doesn't work in my Excel 2010.

Column A is formatted as Text, Column B is formatted as General. There are no extra spaces or unusual characters in Cell A1.

I don't get an error if I do NOT specify the second argument (number characters) otherwise I do get the error instead of the expected result: "le".

Even when the cursor is placed alongside the 2 in the right() function second argument field Excel doesn't make bold the num_chars argument underneath. It's like Excel doesn't accept the second argument I have provided?

It looks like your function list separator has changed and rather than , you will need to use |.

It may be that your "list separator" setting in your system language settings has been changed or is dependent on your language. For English , is common, but in other languages ; is used instead. On Windows 10 2004 you can get to the settings by Settings → Time & Language → Region → Additional date, time & regional settings (opens old control panel) → Change date, time or number formats (aka Region) then under Additional Settings you should be able to change the following.

This will be system wide, so be sure you want to do this. If other people use this machine they may find it odd or confusing for it to have changed.

More information can be found at Force Excel to use commas (,) instead of semicolons (;) in separating formulas