Hi All,

The following is an example text string that I wish to parse into a set of
separate values in a column in a worksheet, the individual values of each
string are those that appear between the <STATUS and </STATUS markers.
There are potentially 50 strings but once the first empty string is found
there are no more past that point.

TIA
Cheers
Nigel

<STATUS19/02/200414:59ELSTREE BRANCH Delivered
HARCOURT</STATUS,</STATUSLINE1<STATUSLINE2
<STATUS18/02/200423:07ELSTREE BRANCH Arrived At Depot</STATUS,
</STATUSLINE2<STATUSLINE3
<STATUS10/02/2004 NORWICH BRANCH Item Manifested For
Collection</STATUS,</STATUSLINE3<STATUSLINE4
<STATUS</STATUS, </STATUSLINE4<STATUSLINE5
<STATUS</STATUS, </STATUSLINE5<STATUSLINE6
<STATUS</STATUS, </STATUSLINE6<STATUSLINE7
<STATUS</STATUS, </STATUSLINE7<STATUSLINE8
<STATUS</STATUS, </STATUSLINE8<STATUSLINE9
<STATUS</STATUS, </STATUSLINE9<STATUSLINE10




----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---