| Welcome to WebmasterWorld Guest from 188.8.131.52 |
register, login, search, subscribe, help, library, PubCon, announcements, recent posts, open posts,
|Pubcon Platinum Sponsor|
| 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.
WebmasterWorld ® and PubCon ® are a Registered Trademarks of Pubcon Inc.
© Pubcon Inc. 1996-2012 all rights reserved