title: Convert a hex string to base64 in an Excel function
body: <p>I have a lengthy string of hex values to convert to base64.</p>
  
  <p>I'm looking for a simple format cell function such as <code>=Hex2b64(Hexstring)</code> that will accept any length of hex characters.</p>
  
  <p>I have been using <a href="http://home.paulschou.net/tools/xlate/" rel="nofollow noreferrer">http://home.paulschou.net/tools/xlate/</a> to do my conversion manually. The conversion works and the data is received by all relevant databases and parsed appropriately.</p>
  
  <p>The data I am receiving is hex represented binary, which has been converted in multiple blocks and concatenated into long hex strings in accordance with project documentation that I am not privy to.</p>
  
  <p>A typical Input String would be:</p>
  
  <pre><code>Hex= 00014088F6650101393939393939392D30304646463238313030000343332353430342D35353FA10000002805900100002805
  </code></pre>
  
  <p>and the corresponding output would be: </p>
  
  <pre><code>B64 = AAFAiPZlAQE5OTk5OTk5LTAwRkZGMjgxMDAAA0MzI1NDA0LTU1P6EAAAAoBZABAAAoAF
  </code></pre>