Every other LET variable fails

[#1]

I am trying to create a script file of the world's currency symbols and am assigning variables to the hex code. For some reason every other variable isn't recognized and fails in the reload. They don't even turn blue. See picture below:

Can anyone see the problem? I assume the syntax for the symbol works since the blue variables work in text boxes.

Thanks in advance!

[#2 · Accepted solution]

The expression in the num#() function is not properly constructed, you have 3 single-quotes.

The format should be num#('4c', '(hex'))

[#3]

What is the target state of vALLSymbol? Should it be 'Lek'? If so, you might want to try something like this:

Let vALLSymbol = chr(num#('4c', '(hex)')) & chr(num#('65', '(hex)')) & chr(num#('6b', '(hex)'));

[#4]

Ah you're right. I created the formula in excel and it used that single quote to format the end of the function as text and was lost in concatenation. Thanks for your help!

My end result is to have a list of all currency symbols, e.g. $, €, ¥.

[rbecher]

Why not using the decimal value and chr() instead of hex?

[#6]

There was no specific reason. Mainly used hex because I knew it worked in that format, I didn't know that chr() used the decimal format. I think I am going to end up using decimal since it looks cleaner and there is less computing necessary.