replace

[rml]

I have a report that is using the following code:
=Replace([Description],". ","." & Chr(13) & Chr(10))

In the descriptions field, it looks like this:
testing. testing123. testing456.

Ater code:
testing.
testing123.
testing456.

After the code, everything should be to the left but it seems to be leaving
some spaces. I know I have spaces after the period in the description field
but thought the code handle it. What am I doing wrong?

Thanks.

 

[KARL DEWEY]

Try this to remove the extra spaces --
=Replace(Replace([Description]," "," "),". ","." & Chr(13) & Chr(10))

The inner replace is to exchange two space to one space.

 

[Klatuu]

=Trim([Description]) & Chr(13) & Chr(10))

Will remove all spaces fore and aft