Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

How To Edit Contacts in .CSV File?

0

I am having .CSV file of my contacts, unfortunetly it consist of lots of duplicates, and i want to delete them in easy way thats is why i saved it in .CSV file.

But, I am unable to do that, as not olny duplicates are to be deleted, some prefixs are also need to be removed, e-mails and numbers are to keep.

Please help me.

Answer
Discuss

Answers

0

There isn't much you can do with a CSV file because it's in TXT format. However, one of the things you can do is to load it into an Excel spreadsheet. You can either look for the file and Open With Excel or open Excel, search for the file and open it. If you follow this way the File Open Dialog will show only Excel files by default so that your CSV file isn't displayed for selection. Change the file type selector at the right bottom (just above the Open button) to "All files".

Once your data are in an Excel spreadsheet you have all the capabilities of Excel to manipulate them, including filters to remove duplicates and Find & Replace to remove prefixes. In fact, the problem turns into one you haven't described but it's managable.

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login