Seek and Destroy!!

[thehog6929]

Hey folks!

Is there a way to Find and Replace (or seek and destroy!!) the special character that represents a carriage return?? It looks like a square.

12345 - 123 AVENUE SWANYTOWN USA 12345

[lucas]

How is it being created and where? Is it from importing data or is it from your code using vbNewLine?

If it is the latter try using Chr(10) instead.

[joms]

hi, try copying your data to notepad... and export it back to word.. check if it will help....

[Paul_Hossler]

Do you have a small sample doc to post?

Paul

[fumei]

And do you want to keep the text as different paragraphs? We need more details about what you are doing. In other words, do you want to change:

12345 - 123 AVENUE SWANYTOWN USA 12345

to:

12345 - 123 AVENUE SWANYTOWN USA 12345

You state you want to remove the square character...so, does the above match what you actually want?