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

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)


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

About Nguyễn Đăng Miền

Information Security, Web Design, Computer Science, Printer Technician

Leave a Reply

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


Scroll To Top

Nhận Tin Mới Từ Nguyễn Đăng Miền

Bạn Hãy Theo Dõi Website nguyendangmien.com để nhận được những tin mới nhất từ Website của mình.

Cảm ơn bạn, bạn vui lòng vào email để hoàn tất việc theo dõi của bạn nhé :)

Something went wrong.