● 새 Bing에 오신걸 환영합니다! 웹용 AI 기반 Copilot  newcha ChatGPT

https://chat.openai.com/chat

는  가끔 에러로 안되어 Bing기반의 newcha ChatGPT

https://www.bing.com/?scope=web&cc=KR

Excel 에서 
"F7 0B 01 19 02 40 11 01 00 B6 EE"
로 변경하는 
"\xF7\x0B\x01\x19\x02\x40\x11\x01\x00\xB6\xEE"
수식을 만들어 주세요

in Excel
"F7 0B 01 19 02 40 11 01 00 B6 EE"
to change to
"\xF7\x0B\x01\x19\x02\x40\x11\x01\x00\xB6\xEE"
please make the formula

You can use the following formula to convert “F7 0B 01 19 02 40 11 01 00 B6 EE” to “\xF7\x0B\x01\x19\x02\x40\x11\x01\x00\xB6\xEE” in Excel:

=CONCATENATE(CHAR(HEX2DEC("F7")), CHAR(HEX2DEC("0B")), CHAR(HEX2DEC("01")), CHAR(HEX2DEC("19")), CHAR(HEX2DEC("02")), CHAR(HEX2DEC("40")), CHAR(HEX2DEC("11")), CHAR(HEX2DEC("01")), CHAR(HEX2DEC("00")), CHAR(HEX2DEC("B6")), CHAR(HEX2DEC("EE")))

This formula uses the CHAR function to convert each hexadecimal value to its corresponding ASCII character and the CONCATENATE function to join them together. You can replace “F7 0B 01 19 02 40 11 01 00 B6 EE” with a cell reference if you want to convert a different value.

I hope this helps! Let me know if you have any other questions.

☞ https://11q.kr 에 등록된 자료 입니다. ♠ 정보찾아 공유 드리며 출처는 링크 참조 바랍니다♠