title: How to split data (that contains a specific character) in a cell using a specific formula?
body: <p>I have data in column "A" and need to split it into four columns. For example</p>
  
  <p>A1 data = <code>1234567~00001.00~H~SX01</code></p>
  
  <p>I simply use the following four formulas in C1, D1, E1 and F1 respectively: </p>
  
  <pre><code>=LEFT(A4,7)
  =MID(A4,9,8)
  =MID(A4,18,1)
  =MID(A4,20,8)
  </code></pre>
  
  <p>But the problem is some cells contain data that looks like: <code>1234567~-2.00~H~XX02</code>.</p>
  
  <p>I would like to know the possibility of splitting data using the separator <code>~</code> that is included in the data cell.</p>
  
  <p>I would like to do it without VBA. But even if you can suggest something using Excel VBA that would be fine.</p>