Special character issue in excel

building reports webintelligence
1

Hi

I am getting the box inside the question mark special character in output of the webi report in the spread sheet. the same is not appearing in the BO webi report.

I used the below formula to eliminate this special character: =Replace([Customer Bill To Postal Code];" ";Char(13))

Anyone help me on this.

Thanks,

stalint (BOB member since 2004-12-14)

2

I used this function =LeftTrim(RightTrim()) its worked for me.

Thanks

stalint (BOB member since 2004-12-14)