Trim formula not working

[aparvez007]

Hi All,


I have text file downloaded from oracle showing trailing space and I use Trim formula but still showing trailing space.


I copy all trailing space and checked the code it showing 160.


Please help....


Thanks

Pavi

 

[vasim]

Have you tried using =CLEAN()

 

[aparvez007]

yes i tried but not working...


Regards,

Pavi

 

[aparvez007]

Hi All,


this formula working =REPLACE(A2,FIND(CHAR(160),A2),FIND(CHAR(160),A2),"")


Regards,

Pavi

 

[shrivallabha]

Searching would have shown you following post:

http://chandoo.org/forums/topic/invisible-character

 

[aparvez007]

Thanks shri...


deb's formula also working...


Regards,

Pavi