I want to replace all "<br>" with a new line character.

[Balaji]

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<BR>BXE to
AXE <new line feed>
BXE

 

[Jacob Skaria]

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

 

[Jarek Kujawa]

select the range containing AXE<BR>BXE
Edit->Replace
Find: AXE<BR>
Replace: AXE and left Alt0010 (from numeric keyboard)