| Welcome to WebmasterWorld Guest from 18.104.22.168 |
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
|Become a Pro Member|
| Forum Library, Charter, Moderators: bill |
Microsoft Windows OS (XP/NT/Vista/Windows 7/8/10) Forum
|Excel regex to split /n into cells|
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.
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 is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved