Welcome to WebmasterWorld Guest from 54.147.63.124

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
posts:329
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)

Administrator

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

joined:Aug 10, 2004
posts:10544
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?