Excel VBA: Split Numbers and Text from a string into Columns : <p>I have a column in my excel in the following format:</p>

<pre><code>Column A
1.2kg
100ml
2m
200
</code></pre>

<p>I need to run the VBA to split the numbers and text separately into two columns as:</p>

<pre><code>Column A | Column B
1.2      |  kg
100      |  ml
2        |  m
200      |
</code></pre>

<p>I've also found a similar question in this site, however it isn't work for my VBA. Can anyone help me on this? </p>

<p>PS. I use excel 2007</p>
