title: Convert HEX to RGB in Excel
body: <p>I have a column "HEX" and three columns "R", "G", and "B".</p>
  
  <p>How can I convert a HEX to RGB, e.g. <code>ff0000</code> to <code>R=255</code>, <code>G=0</code>, and <code>B=0</code>?</p>
  
  <p>I know that the first 2 characters <code>ff</code> belongs to "R", the next 2 <code>00</code> belongs to "G", and the final 2 <code>00</code> belongs to "B". So I will have to use <code>=LEFT(A1, 2)</code> for "R", <code>=RIGHT(LEFT(A1, 4), 2)</code>, and <code>=RIGHT(A1, 2)</code> for the last.</p>
  
  <p>But how can I convert <code>ff</code> to <code>255</code> and <code>00</code> to <code>0</code>, etc.? I guess I will have to do something to parse from hexadecimal (base 16) to decimal (base 10)?</p>
  
  <p>I would like to do it without VBA.</p>