Use VBA to replace continuous space to tab

[mrkhchan]

Hi All,

I have text file like attached.
Can I use some code to replace continuous space to tab or any special char like "|"? so that I can open the file in excel.
Many Thanks.

atacado.txt

[jindon]

Try

Please Login or Register  to view this content.

[mrkhchan]

Many Thanks Jindon. It's ok.

Try

Please Login or Register  to view this content.

[mrkhchan]

Many Thanks Jindon. It's ok.

Try

Please Login or Register  to view this content.