RaulB

thank you, "Variable Set to ASCII Char 10 to %T92%" and then split string by %T92%, worked to separate the copied string by the new line.

they are three separate columns, and the Link, Login, Password are in the same row but in separate cells. thank you for any help you can provide.

I have it as: Link Login Password Link Login Password Link Login Password Link Login Password Link Login Password it is in a macro and want to copy column and separate each Login and Passwords. Rberq how would I be able to apply that into the Macro?

I am trying to open my different accounts and I have them in order of website link, Login, and Password. I want to create a macro to open all the Links and insert password and emails. However it takes so long to go to each cell to copy that I want to copy the full column and split by new line. Is this possible and if not whats a proficient way to go about this?