homepage Welcome to WebmasterWorld Guest from 54.204.215.209
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Pubcon Website
Home / Forums Index / Microsoft / (deprecated) Microsoft Windows OS (XP/NT/Vista)
Forum Library, Charter, Moderators: bill

(deprecated) Microsoft Windows OS (XP/NT/Vista) Forum

    
Excel regex to split /n into cells
SilverLining




msg:3951575
 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




msg:3955111
 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 / (deprecated) Microsoft Windows OS (XP/NT/Vista)
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About
© Webmaster World 1996-2014 all rights reserved