Use the 'Find and Replace' option

--Select the column/range and hit Ctrl+H
--Hit 'Options' in Find/Replace window.
--Make sure you select 'Formulas' in 'Look In'
--Find What: <BR
--Replace With: Hit the keys Ctrl+j
--Hit Replace All

If this post helps click Yes
---------------
Jacob Skaria


"Balaji" wrote:

I would like to replace all html tags inside my workbook by a new line
character inside the same cell.
Example:
I want to change AXE<BRBXE to
AXE <new line feed
BXE