Replace give error 'Formular is to loong'

[Trampedach]

Hi,

I extract information from a DB into an excel sheet.
Because crlf is shown as square, i would like to replace crlf.

It is working okay, but in one cell, replace will not work.
If I do a replace from menue, an error is given, 'formula is too long'...
It can't get an error from VBS code.

In attached my file incl VBS code. Problem is in cell B3.

Do you have a cloue that could solve this issue?

Regards Ivan

[teylyn]

without looking at your file, have you considered using Find and Replace instead of code?