Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
As you can see on another thread, I had some problems making some cells
being cut down to another row. (thread: http://groups.google.com/group/micro...ecc6f058e0f01e) Tom Ogilvy did a pretty nice job and made a script that did everything I needed. But now I need something else. I want to break more than one line, like: P|00000|ICMS|IPI|T|123|999|T|123|456 P|00001|ABCD|ASD|T|456|666|T|888|4456 P|00002|LINK|LUNK|T|789|333 |T|321|3214 Would become: P|00000|ICMS|IPI T|123|999 T|123|456 P|00001|ABCD|ASD T|456|666 T|888|4456 P|00002|LINK|LUNK T|789|333 T|321|3214 A proposal would be that every cell with just a "T" would be triggered a new row. Remembering that each "|" means a cell divider. Thanks in advance specially to Tom Ogilvy, which did a great job. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Reference only part of a cell | Excel Discussion (Misc queries) | |||
Reference to a Variable Part of a Cell | Excel Worksheet Functions | |||
Reference a cell as part of a file name | Excel Programming | |||
Copy and Paste macro needs to paste to a changing cell reference | Excel Programming | |||
Copy and Paste part II | Excel Programming |