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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

New line Within CSV 2
Replace /n with a XHTML <br /> using string.replace 3
replace new line character 3
Reading XML File, '<br>' gives 'Element' is not a valid node type 4
I want to eliminate the first character in several lines 7
Find and replace # with new line in a cell. 6
Different renderings of <br/> and <br></br> in IE6 8
How to remove or replace a carriage return character in a cell? 2

Back
Top