richardthelionheart
Board Regular
- Joined
- Mar 25, 2016
- Messages
- 95
- Office Version
- 2016
- Platform
- Windows
<colgroup><col width="64"></colgroup><tbody>
[TD="width: 64"]SLICK BUDDY (7) is an exciting prospect and unbeaten in 3 starts this T/D with a blinding 29.51 PB. Safe beginner with a mix of speed and strength and set to maintain the perfect record. One to beat. MILEY NISMO (3) is the main danger. Speedy ***** who led throughout in 29.78 last week. ALL AMERICAN BOY (8) and PRINCESS ZESTA (6) have place claims.
[/TD]
</tbody>
When I copy and paste this text from the greyhound site, I get just one row of text with a number of sentences. (Not like it turned out above, have no idea what happened there !) Anyhow, imagining that all this text above is in one continuous horizontal line, what I'm trying to do is this. I want to ' break it up ' into sentences that are shown on consecutive rows. like this -
<colgroup><col style="width:48pt" width="64" span="10"> </colgroup><tbody>
[TD="width: 640, colspan: 10"]SLICK BUDDY (7) is an exciting prospect and unbeaten in 3 starts this T/D with a blinding 29.51
PB.
[/TD]
[TD="colspan: 9"]Safe beginner with a mix of speed and strength and set to maintain the perfect record. [/TD]
[TD="colspan: 2"]One to beat.[/TD]
[TD="colspan: 4"]MILEY NISMO (3) is the main danger.[/TD]
[TD="colspan: 6"]Speedy ***** who led throughout in 29.78 last week.[/TD]
[TD="colspan: 7"]ALL AMERICAN BOY (8) and PRINCESS ZESTA (6) have place claims.[/TD]
</tbody>
(Still having problems demonstrating) But there should be 6 rows here, which I have to just imagine now ! Anyhow I'm trying to ' read' the one line of text and ask excel to find the full stops/periods and then put each sentence on a separate line.
I have no idea how to do this or even if it's possible
Any help will be gratefully received.