title: How to trim white space between text in power bi?
body: <p>I have a column of random text with random amounts of white space between characters and strings. I know how to trim leading and trailing white space and I think I know how to remove all white space but I am struggling to remove only excess white space. Here is an example of my column:</p>
  
  <pre><code>Column1
  I   have    too          much   space
  123    big gap     456
  asdfg   2z1xc2            .
  </code></pre>
  
  <p>I would like to either create a new column or transform the current one to look like this:</p>
  
  <pre><code>Coumn1
  I have too much space
  123 big gap 456
  asdfg 2z1xc2 .
  </code></pre>
  
  <p>Thanks in advance!</p>