Data Slashing

[rc_schawel]

Is there any technique to remove all text before AND/OR after a <p> tag?

For example, I need to separate the following data into 2 columns:

<p>Description of CD here.</p><p>Track listing: 1) A 2) B</p>

I need to move the description part into column A and track listing part into column B. I need some kind of formula or anything that can do 7000 entries in the blink of an eye.

What I was thinking is to duplicate the information into both column A AND column B. The in column A, I would delete everything after the </p>. And in column B, delete everything before the <p>.

But if someone has a better idea, please slap me in the face with it.

Thanks!

 

[rc_schawel]

Sorry, I didn't know the P tags wouldn't show. Rookie mistake.

Is there any technique to remove all text before AND/OR after a P
tag?

For example, I need to separate the following data into 2 columns:

Description of CD here.Track listing: 1) A 2) B


I need to move the description part into column A and track listing part into column B. I need some kind of formula or anything that can do 7000 entries in the blink of an eye.

What I was thinking is to duplicate the information into both column A AND column B. The in column A, I would delete everything after the first /P tag. And in column B, delete everything before the second P tag.

But if someone has a better idea, please slap me in the face with it.

Thanks!

 

[Armando Montes]

Try text to columns and skip the columns not needed

 

[rc_schawel]

I'm sorry. I don't quite understand your answer. Please elaborate.