Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a long string that I need to parse into separate lines. Has anyone got
a function that will do this neatly? I'm having a devil of a time... For example, parse the following: This is an example of a string parser that will return only one line at a time. The first line ends at "one" in the previous line and it is marked by a "vbCr" character. The second line ends at "and" and the third line ends at "at". The above would return "This is an example of a string parser that will return only one" as the first line; The second line is "line at a time. The first line ends at "one" in the previous line and", etc. Each line is marked by a "vbCr" character...thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to parse long spaced entry into multiple cells??? | Excel Worksheet Functions | |||
Parse A String into Two | Excel Worksheet Functions | |||
Parse this string | Excel Discussion (Misc queries) | |||
Q: parse string | Excel Discussion (Misc queries) | |||
String Parse | Excel Programming |