WORD-DELIMITED string as opposed to character delimited string

Joined
Dec 23, 2005
Messages
2
Reaction score
0
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: (please scroll to the right).



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 in excel only have character delimiters, and I would be really grateful if you could help me with a vba 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top