title: Replace cell contents with multiple cells
body: <p>Is there any way to replace a cell with multiple cells and have them relate to other multiple cell substitutions?  The following example shows the substitution of the first line of worksheet A.  </p>
  
  <p>Worksheet A:</p>
  
  <p><img src="https://i.stack.imgur.com/sTmQK.gif" alt="pic2"></p>
  
  <p>With a substitution logic in Worksheet B where the items in column A should be replaced with the corresponding item in column B. Everywhere zd is used, it should become a_zd, b_zd, and y_zd.  Everywhere fs is used, it should become c_fs, y_fs, and z_fs. Example: A1=zd and B1=a_zd; A2=zd and B2=b_zd; A3=zd and B3=y_zd; A4=fs and B4=c_fs; A5=fs and B5=y_fs; A6=fs and B6=z_fs:</p>
  
  <p><img src="https://i.stack.imgur.com/YlI3k.gif" alt="pic2"></p>
  
  <p>The substitution of the first line in Worksheet A will have a result of Worksheet C. Example: A1=a_zd and B1=c_fs; A2=a_zd and B2=y_fs; A3=a_zd and B3=z_fs;  A4=b_zd and B4=c_fs; A5=b_zd and B5=y_fs; A6=b_zd and B6=z_fs;  A7=y_zd and B7=c_fs; A8=y_zd and B8=y_fs; A9=y_zd and B9=z_fs;:</p>
  
  <p><img src="https://i.stack.imgur.com/yWfVZ.gif" alt="pic2"></p>