Help split string in a text array
Posted on 2013-12-19
I have an array a(i).
The array contains text like
1. The Beach
2. The Song
3. The Sun
How do I split the existing array into two parts:
(1) is the text up to the full stop eg 1.
(2) is the balance of the text eg The Beach
If there is no fullstop "." (1) would be empty (2) would be the whole lot of the text.
Then I've got to populate my table. I can move through the table okay, I just not sure how to work with the splitting the text - it does my head in!
For k = 1 To i - 1
selection.range.text = (1)
selection.moveright wdcell, 1
selection.range.text = (2)
Can someone please help me get (1) and (2) from my array a(i) please.