Excel – Convert Hex string value to Hex number

hexadecimalmicrosoft excelworksheet-function

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.

Related Question