Say A1 contains the string "f26e". It's a hex value that I want to use in the Unichar function, but since it's a string, I would need to convert it as a number (UNICHAR(A1) returns an error in value). VALUE() doesn't work. I guess it can only take decimal values.
Thanks!
R.
Best Answer
You can use
HEX2DEC
function to convert hexadecimal numbers to decimal ones.