Question

如何将excel中的字符串批量转换为16进制表示

如图中的字符串如何批量转换为后面的16进制值

Answer 1

过程有些曲折，但是道理很简单，公式如下，
=DEC2HEX(CODE(A2))&DEC2HEX(CODE(MID(A2,2,1)))&DEC2HEX(CODE(MID(A2,3,1)))&DEC2HEX(CODE(MID(A2,4,1)))&DEC2HEX(CODE(MID(A2,5,1)))&DEC2HEX(CODE(MID(A2,6,1)))&DEC2HEX(CODE(MID(A2,7,1)))&DEC2HEX(CODE(MID(A2,8,1)))&DEC2HEX(CODE(MID(A2,9,1)))&DEC2HEX(CODE(MID(A2,10,1)))&DEC2HEX(CODE(MID(A2,11,1)))&DEC2HEX(CODE(MID(A2,12,1)))&DEC2HEX(CODE(MID(A2,13,1)))
下拉即可