Greetings everyone,

I've been working on this for a while without success.
How can I split the following type of text into word-delimited tokens,
so that each token gets created when upon the next "Full Name" string,
and each token gets placed on a new line, for example this type of
text:

FULL NAME: XXXXXX SURNAME: XX FIRST NAME: XXXX FUNCTION: XXX FULL
NAME:XX SURNAME:X FIRST NAME:X FUNCTION:X FULL NAME:XXX SURNAME:XX
FIRST NAME:X FUNCTION:X FULL NAME: 12345 SURNAME: 45 FIRST NAME: 123
FUNCTION: 6789

Being split into this one?

FULL NAME: XXXXXX SURNAME: XX FIRST NAME: XXXX FUNCTION: XXX
FULL NAME:XX SURNAME:X FIRST NAME:X FUNCTION:X
FULL NAME:XXX SURNAME:XX FIRST NAME:X FUNCTION:X
FULL NAME: 12345 SURNAME: 45 FIRST NAME: 123 FUNCTION: 6789


The features available only have character delimiters, and I would be
really grateful if you could help me with a macro to achieve the above
re-formatting. Note that each token has a variable width, begins with
"Full Name" and ends with the piece of text after "Function". I await
your reply!

THanks


--
jackal2k6
------------------------------------------------------------------------
jackal2k6's Profile: http://www.excelforum.com/member.php...o&userid=29872
View this thread: http://www.excelforum.com/showthread...hreadid=495746