Replace Html Tag() With Alt+enter In Excel

I am working on VBA, but I have one problem of how to replace a tag of HTML with Alt+Enter. For example, If I type a sentence: Hello World. In shell of Excel, I press on Alt+Enter

Solution 1:

The <br> tag in HTML just gives you a line break.

In VBA, you can accomplish the same thing using the vbNewLine constant.

The Replace function will come in handy for this.

Dim input AsString
input = "Hello<br>World!"Dim result AsString
result = Replace$(input, "<br>", vbNewLine)

Solution 2:

You can use Excel formula:

=SUBSTITUTE(B4, "<br>", " Alt+Enter ")