| Welcome to WebmasterWorld Guest from 22.214.171.124 |
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
| Forum Library, Charter, Moderators: bill |
(deprecated) Microsoft Windows OS (XP/NT/Vista) Forum
|Excel regex to split /n into cells|
| 3:21 pm on Jul 13, 2009 (gmt 0)|
Is there a regex to split data in one cell into many cells in Excel or Open Office? The data within one of the cells looks something like this:
blah blah /n blahblah blah /n blah blah
There are at least 100 rows in the file, so I don't want each /n to create a new cell. Is this possible?
Thanks in advance.
| 11:38 pm on Jul 18, 2009 (gmt 0)|
if i were doing this i would export the data and clean it up with a perl script.
are you looking for a solution within excel for this?
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
© Webmaster World 1996-2014 all rights reserved