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

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

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

To replace all instances of "&lt;br&gt;" with a new line character in a specific cell:

1. Select the cell that contains the text you want to replace.
2. In the formula bar at the top of the screen, type the following formula:
   
   
   Formula:

   ---

   =SUBSTITUTE(A1,"<br",""&CHAR(10)&"") 


   ---

   Note: Replace "A1" with the cell reference of the cell you want to modify.
3. Press Enter on your keyboard.

To replace all HTML tags in your workbook with a new line character inside the same cell:

1. Press Ctrl + H on your keyboard to open the Find and Replace dialog box.
2. In the "Find what" field, type "<*" (without the quotes).
3. In the "Replace with" field, type ""&CHAR(10)&"" (without the quotes).
4. Click the "Options" button to expand the dialog box.
5. Under "Search", select "Workbook" to search all sheets in your workbook.
6. Under "Within", select "Sheet" to search within each cell.
7. Click "Replace All" to replace all instances of HTML tags with a new line character in your workbook.

Note that this will modify all cells in your workbook that contain HTML tags, so make sure to save a backup copy of your workbook before proceeding.

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

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

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

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


On 19 Paź, 08:33, 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