homepage Welcome to WebmasterWorld Guest from 54.196.62.23
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Microsoft / Microsoft Windows OS (XP/NT/Vista/Windows 7/8/9/10)
Forum Library, Charter, Moderators: bill

Microsoft Windows OS (XP/NT/Vista/Windows 7/8/9/10) Forum

    
Excel regex to split /n into cells
SilverLining

5+ Year Member



 
Msg#: 3955112 posted 3:21 pm on Jul 13, 2009 (gmt 0)

Hi everyone,

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.

 

phranque

WebmasterWorld Administrator phranque us a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month



 
Msg#: 3955112 posted 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?

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Microsoft / Microsoft Windows OS (XP/NT/Vista/Windows 7/8/9/10)
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved