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

  • Thread starter Thread starter Balaji
  • Start date Start date
B

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
 
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
 
select the range containing AXE<BR>BXE
Edit->Replace
Find: AXE<BR>
Replace: AXE and left Alt0010 (from numeric keyboard)
 
Back
Top