Welcome to WebmasterWorld Guest from 54.205.251.179

Forum Moderators: bill

Message Too Old, No Replies

Excel regex to split /n into cells

   
3:21 pm on Jul 13, 2009 (gmt 0)

5+ Year Member



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.

11:38 pm on Jul 18, 2009 (gmt 0)

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



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?