Thanks for the reply. What I'm trying to do specifically is compare 2 files, they can be text or csv,(excel would be great, but I know I can't
1. Compare the files, they typically have just a single column as I paste them from excel. The values are usually something like computer names, user names, etc, most times there's no space in between characters, but perhaps a comma, and I can remove the spaces but not the comma if it were a list of names.
2. I am not "great" at using the visual diff option as I'm not clear on what it shows, I know the color red is if it's in 1 file but not the other and then green if it's in the 2nd file but not the first, but I could be wrong on the color scheme.
3. I want to see the differences, but then export the differences/save them. What I need is to have the differences from either file, so right now I have a file with 1000 entries, and 1 file with 400. I want to find the items that exist in both files, and then come up with a list of them and then save the results, then I want to remove the items from the file with 1000 entries and save that list. I'd also like to be able to save the file with 1000 entries and "highlight" them or "notate" them so that I know that exist in the file with only 400 entries.