How to Remove Unprintable Invisible characters from data imported from ERP Module

[somnath6309]

Dear Sir/ Madam,

I have attached herewith an excel file which contains sheet1 that represents data imported from ERP Module.
I wanted to extract all voucher nos. using some formula for which the space between two consecutive voucher nos. should be blank.

But ISBLANK Formula shows that the space contains some unseen unprintable characters. I wanted to remove the blanks so that i can use my formula to extract vourcher nos.

I have also given the vba code in sheet2 which is not working properly.

i need your help so that the code actually works properly. Waiting for your replay in my emai: [email protected]

Regards
Somanth Chatterjee

[Pete_UK]

Highlight column C, click on Data | Text-to-columns, then click Finish.

Hope this helps.

Pete