The string after .com/ is different in each link.
To download them (rather leech them to a different hosting ) I have been given login I’d and password of the host .
I wish you add the login I’d and password to each link so that they become direct and could be downloaded at any location ..
Something like
One trick you could use if you have username and password stored in separate columns is extract the text after https;// part, append the username and password to the url and reattach the https;// part.
Assuming A is link,
will give you everything after the https:// . This basically looks for the position of first ‘/’ then increments that index by 1 and gets everything to the right of it.
I am assuming all first parts are
https://,
If not then you will need to extract the first part as well using
Assuming column B is username and C is the password
should embed username and password into the link or if the links have different first parts
If the username and passwords are stored elsewhere you will need to replace B1 and C1 with the appropriate lookup based on where they are stored.
User I’d and password aren’t on the Excel sheet, but the credentials are same, its just a matter of adding the same credentials after http:// to every link and also have @ at th3 and if the password
Any simpler way? coz I am 0 when it comes to such things
assword@xyz.com/1234567