replace html codes with line break

[princess.sandra]

I have a rows of text which have html code <br> and I want to replace
that with a line break. can i do a find and replace? I have about 2000
rows, too many to do by hand.

my text appears as such
apple<br>banana<br>orange<br>mango
and I would like it to appear as

apple
banana
orange
mango

 

[Guest]

Click on A1
Pull-down Edit > Find
in the findwhat field enter <br>
click on the replacefield
Hold down the alt key and touch 010 in the numeric keypad then release the
alt key.
click replace all

 

[DJH]

Do a Find and Replace <br> and replace with a comma ,
Then Data|Text to Columns... Delimited with a comma selected to convert to
seperate columns


apple<br>banana<br>orange<br>mango
becomes
apple,banana,orange,mango
then
apple banana orange mango