Convert Text to HEX

p45cal · #1 07-28-2018, 03:20 PM

Ahh… shame.

I see the OP has Excel2016 for the Mac and that does have the CONCAT function.

I can't think of an array formula to do this off the top of my head, but the following works:

Code:

=DEC2HEX(CODE(MID(A1,1,1)))&DEC2HEX(CODE(MID($A1,2,1)))&DEC2HEX(CODE(MID($A1,3,1)))&DEC2HEX(CODE(MID($A1,4,1)))&DEC2HEX(CODE(MID($A1,5,1)))&DEC2HEX(CODE(MID($A1,6,1)))&DEC2HEX(CODE(MID($A1,7,1)))&DEC2HEX(CODE(MID($A1,8,1)))

but you lose all simplicity and speed.

If you:
=SUMPRODUCT(DEC2HEX(CODE(MID(A2,{1,2,3,4,5,6,7,8}, 1))))
you can see all the results in the SUMPRODUCT dialogue box. Perhaps you can think of a way.

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