title: How do I split a string with white space in Google Sheet that include white space in output
body: <p>I have the following string :</p>
  
  <p><code>A||B| |C||||| |</code> and I want the following output <code>A|.|B|.|C|.|.|.|.|.|</code></p>
  
  <p>When I'm doing this <code>=SUBSTITUTE("A||B| |C||||| |","||","|.|")</code> I have the following output <code>A|.|B| |C|.||.|| |</code>. why not all the space between <code>|</code> are filled with <code>•</code> ?</p>
  
  <p>The main idea behind this is to replace each white space with a specific character so I can use the Split function (which doesn't output white space otherwise)</p>