Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
WORD-DELIMITED string vba macro for excel/word
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how we find specific word from string in excel and compaire it. | Excel Worksheet Functions | |||
Frequency of a word string in an excel database | Excel Discussion (Misc queries) | |||
Pull last word from a text string in Excel | Excel Worksheet Functions | |||
identify a word in a string then change the format of that word | Excel Programming | |||
Use Word VBA string in Excel macro? | Excel Programming |