I have a number of domain names in column A with external links that go to GoDaddy auctions. How do I copy these links and add to Column B ?
I have a number of domain names in column A with external links that go to GoDaddy auctions. How do I copy these links and add to Column B ?
B1=HYPERLINK("https://www."&A1&"/") and drag down.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
When i paste this B1=HYPERLINK("https://www."&A1&"/")
into column b nothing happens I just see B1=HYPERLINK("https://www."&A1&"/")
Paste in cell B1 te formula =HYPERLINK("https://www."&A1&"/")
After that you can drag the formula down.
This doesn't do what i want it to do
If you hover over the domain name in column A you will see the option the copy link. This is the link I want in column b
https://docs.google.com/spreadsheets...it?usp=sharing
Then you should show the expected result of column B in your file.
You should see the result that I'm looking for in column B1 https://docs.google.com/spreadsheets...it?usp=sharing
See if the following steps provide your desired results:
- hoover over domain name in column A1;
- click on the copy link icon;
- right click cell B1;
- click on insert link;
- paste the copied link and press Apply.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks