Space in excel file from PDF file

[Vignesh Veerasamy]

Dear Gurus,

Recently I copied a list of line items from PDF file to excel,were I found five space in each cell.
I tried removing space using "Trim & Control+H" but unable to removed all spaces.
Kindly suggest for solutions for the same.

 

[Hui]

Vignesh
Sounds like you have an ASCII character 160 in your file
Try: =SUBSTITUTE(A1,CHAR(160),"")

 

[Vignesh Veerasamy]

Vignesh
Sounds like you have an ASCII character 160 in your file
Try: =SUBSTITUTE(A1,CHAR(160),"")

Dear Hui Sir,

Thanks a lot,working fine.