Search the Community
Showing results for tags 'split string'.
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?
This is an example of the Order ID format we use - "615900205-10-1". The first part of the number is what I need to keep and I need to delete everything else. The problem is, none of the sections are a consistent number of digits so I am unsure how to use the "Delete part of text" variable where it asks for a Starting Position. I looked into Split String and choosing "-" for Split string on, however it just returned this "615900205101". So how can I delete everything to the right, starting with the first dash, if the starting position is not constant? Thanks.