title: Excel formula to remove comma, spaces, period and add a text
body: <p><strong>Context</strong></p>
  <p>I have data like this:</p>
  <blockquote>
  <p>Reyes, Ma. Luisa Jun-Oh, Junee Carter, John Jr.</p>
  </blockquote>
  <p>I need to use a combination of excel formulas in one cell to remove commas, periods, spaces and replace with underscore.  Also need to add text after the names (to be used as PDF filename).</p>
  <p><strong>Expected output</strong></p>
  <blockquote>
  <p>Reyes_MaLuisa_Text123; JunOh_Junee_Text123; Carter_JohnJr_Text 123 (no
  period and trailing space removed)</p>
  </blockquote>
  <p><strong>What I've tried</strong></p>
  <blockquote>
  <p>Formula used: =REPLACE(I2,FIND(&quot;, &quot;,I2,1),2,&quot;_&quot;) &amp; &quot;_Text123&quot;  where I
  is the name field.</p>
  </blockquote>
  <p>Thanks.</p>