Welcome to WebmasterWorld Guest from

Forum Moderators: bill

Message Too Old, No Replies

Excel regex to split /n into cells



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

10+ 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?

Featured Threads

Hot Threads This Week

Hot Threads This Month