replace

  • Thread starter Thread starter rml
  • Start date Start date
R

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.
 
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.
 
Back
Top