title: Obtaining the equivalent to printf or String.Format in Excel
body: <p>I seem to spend a large amount of my time in spreadsheets working on formulas like:</p>
  <pre><code>=&quot;some text '&quot; &amp; A1 &amp; &quot;', more text: '&quot; &amp; A2 &amp;&quot; etc.&quot;
  </code></pre>
  <p>It would be much quicker to use a printf or String.Format string like</p>
  <pre><code>=String.Format (&quot;Some text '{0}', more text: '{1}'&quot;,A1,A2)
  </code></pre>
  <p>Is there anything like this built in to Excel, or can I call out to CLR?</p>