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)

Full Member

10+ Year Member

joined:July 27, 2005
votes: 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.

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


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

joined:Aug 10, 2004
votes: 8

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?