Lưu File Exel sang CSV có dấu “:” EU CSV Version

4.3/5 - (921 votes)

There are various approaches possible like Manual, VBA, Formula etc..But, I think most straightforward is following –

1. Save the file as Text (tab delimited).

2. Open the file in Notepad and copy the entire space between two values. (See, highlighted section between two values as in below picture)

Image

3. Now CTRL+H and in Find What: box, Paste the space which you copied in step 2. And in Replace With: box put ; (semi colon)

4. Replace All, save.

5. Change .txt filename to .CSV

Leave a Reply

Your email address will not be published. Required fields are marked *