title: Convert a value from cm to inch in excel
body: <p>A number in centimeter format can be converted to inch using this function:</p>
  
  <pre><code>=CONVERT(A1,"cm","in")
  </code></pre>
  
  <p>What i want is that instead of replacing the number, putting the converted number next to original one. Actually it's a more complicated situation:</p>
  
  <p>Original cell:</p>
  
  <pre><code>35 - 45 cm
  </code></pre>
  
  <p>After convertion (all in one cell):</p>
  
  <pre><code>35 - 45 cm
  (14 - 18 inch)
  </code></pre>
  
  <p>So, how to do this in excel in an automated way since there are many cells in this format, maybe using a macro?</p>