I bet no one can answer this STRANGE question! Copy/pasting email account passwords from Excel shows wrong password, but its not

I am using Windows 7 and Excel 2010, I would say I am a 7-8 level of proficiency in Excel. I have a business degree and use Excel very often. I have tried this on 3 different computers. Here is my question:

I have a text file of 100 randomly generated usernames and passwords to a popular email site. I use this for my business. When I try and use one of these password/username combos to login to the email account via copy/paste from a Word or .txt document, it works fine. However when I transfer this external data from that same .txt file into an Excel CSV and then try to copy/paste the password into the login screen, it will not work. Does that make sense? I can look at the password within excel and manually type it into the login screen exactly as I see it with no problem whatsoever. I have removed any and all formatting that may exist. The password physically appears the exact same. However when I copy/paste from the Excel file into the password box, I see the dots pop up, showing me that the password transferred, however when I click "login" it says the password is wrong. So I know that all the passwords are correct because I can manually type them in. And I know that it isn't merely a copy/paste problem because I can copy/paste them from Word or anywhere else with no problem. I've tried this using both Excel 2010 and 2007 and same result. Please help!

Almir's picture

Save .txt file with different encoding before transfer to Excel

Try saving .txt file with different encoding (maybe "Unicode") before transferring it to Excel. I guess it was saved as ASCII file.

Nick's picture

does it work if you remove

does it work if you remove the last character ?

a place to start

Try checking the ascii value of the csv password vs. the one you typed to see if there is a difference there. You can use the following link.

http://www.asciivalue.com/

Regards,
-Scott

Not sure how exactly to do

Not sure how exactly to do that.

I have discovered that google chrome may be the problem. I am able to copy/paste them from excel into any other browser successfully except Chrome. Why would this be?