Help with Removing Blanks in the field

[pp2014]

I have the product field with following info:

Product

Atrilin  Amox HC  Retin-A Micro

Tobi Cream Luzu Cream

I want the output as follows:

Product

Atrilin  AmoxHC  Retin-AMicro

TobiCream LuzuCream

I tried compbl function but it does not work.

I would appreciate any help with this.

[Reeza]

y = tranwrd(x, " Cream", "Cream");

---

@pp2014 wrote:

I have the product field with following info:

Product

Atrilin  Amox HC  Retin-A Micro

Tobi Cream Luzu Cream

I want the output as follows:

Product

Atrilin  AmoxHC  Retin-AMicro

TobiCream LuzuCream

I tried compbl function but it does not work.

I would appreciate any help with this.

---