Convert Text to HEX

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Convert Text to HEX

FAQ

Thread Tools

Display Modes

07-28-2018, 07:46 AM

NoSparks

Windows 7 64bit Convert Text to HEX

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

@ 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.

Tags

covert, hex, text

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I need to convert shaded text into highlighted text on about 80 different long documents. VBA macro?	AustinBrister	Word VBA	8	05-28-2015 02:42 PM
convert text to tables	oraenthu	Word	8	03-17-2015 10:22 AM
Convert Text To Table: Separate text at (Other)?	tinfanide	Word VBA	2	01-12-2015 05:26 AM
Convert image-text hybrids into plain text	morlack	Excel	4	12-03-2014 05:29 PM
My plain text post got converted to rich text in a reply, how to convert it back?	david.karr	Outlook	0	01-05-2012 09:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:29 AM.