Thread: Convert Text to HEX
View Single Post
 
Old 07-28-2018, 07:46 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
@ p45cal
that formula looks neat, how do I get it to work?
Having Excel 2010, have changed to
=CONCATENATE(DEC2HEX(CODE(MID(A2,{1,2,3,4,5,6,7,8} ,1))) )
but only get conversion of the first character.
Reply With Quote