ExcelBanter - Replacing \r\n #13#10 to <br in a string?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Replacing \r\n #13#10 to <br in a string? (https://www.excelbanter.com/excel-programming/418291-replacing-%5Cr%5Cn-13-10-br-string.html)

jodleren

Replacing \r\n #13#10 to <br in a string?

Hi all

In PHP I'd used strreplace..... is there such a function in Excel VBA,
so I can replace all strings in on string?

WBR
Sonnich

Peter T

Replacing \r\n #13#10 to <br in a string?

See the intuitively named Replace function (n/a in xl97)

Regards,
Peter T

"jodleren" wrote in message
...
Hi all

In PHP I'd used strreplace..... is there such a function in Excel VBA,
so I can replace all strings in on string?

WBR
Sonnich

All times are GMT +1. The time now is 04:47 PM.