title: Excel VBA Repeated Find and Replace /from a Table/
body: <p>I'm trying to build a macro in Excel using <code>VBA</code> – it should convert a slew of rows of strings like <code>“YU-RN-PE-LT-JW-MN”</code> into other things <code>“L3,N6,W2,P9,V7,F2”</code>  (the dashes also ought to become commas) according to an arbitrary table specifying <code>“YU”</code> in one column, <code>“L3”</code> in another and so on. </p>
  
  <p>It's the table thing that complicates normal search and find, and the repeated looking that makes normal Vlookup inadequade. </p>
  
  <p>Would appreciate any help. Also please note that I've never used VBA before trying to build this macro, so assume I don't know anything.</p>