Hi, I am trying to transfer a large amount of text from word to excel but I want to keep the numbered bullet points in a different cell than the rest of the text. I was wondering what would be the best way to go around this.
E.g. Text on MS word would be
1. bla bla bla
2. bla bla bla
2.1 bla bla bla
3. bla bla bla
and would go to excel as
<tbody>
</tbody>
Either making an 'If function' asking if the first few characters in the string where numbers and placing them in a different cell to the text or is there a simple macro that I could use.
My knowledge of excel is quite basic so i might ask a few questions but any help would be much appreciated.
Cheers
B_ae
E.g. Text on MS word would be
1. bla bla bla
2. bla bla bla
2.1 bla bla bla
3. bla bla bla
and would go to excel as
Col. 1 | Col. 2 |
1 | bla bla bla |
2 | bla bla bla |
2.1 | bla bla bla |
3 | bla bla bla |
<tbody>
</tbody>
Either making an 'If function' asking if the first few characters in the string where numbers and placing them in a different cell to the text or is there a simple macro that I could use.
My knowledge of excel is quite basic so i might ask a few questions but any help would be much appreciated.
Cheers
B_ae