All Questions
Tagged with url microsoft-excel
18
questions
0
votes
2
answers
1k
views
Excel 365: Is there a way to fully protect (hide or encrypt) the url provided for a Data Source?
I'm importing data to Excel 356 using a data source "From webb". The url provided includes an API key that I do not want to share with others when I share the Excel file. I can use Protect ...
0
votes
1
answer
725
views
How can I use Excel to parse Google Analytics UTM URLs
How could I take a URL such as...
website url/directory/another-directory?utm_id=inc0000000&utm_source=facebook&utm_medium=affiliate&utm_campaign=2021+q3+campaign&utm_content=post&...
0
votes
1
answer
7k
views
Drag and drop file to get its flename/path in Excel [closed]
I have a table like so
File | Filename |...
foo | \a\b\c\foo.txt |
foo2 | \a\b\c\foo2.txt |
foo3 | \a\b\c\foo3.txt |
Currently, every time I add a file, I have to manually enter ...
0
votes
1
answer
1k
views
Extract all URLs from CSV /Excel file and put it in a separate column
I have a csv file. When I open the csv file in Microsoft excel, I have a column.
Each cell in the column has number of paragraphs. each paragraph has many URLs.
I am looking to extract all URLs in ...
0
votes
2
answers
3k
views
Is it possible to extract url from hyperlinks in excel if it's setup like this?
I have few hundred lines like this in excel file. I have tried to copy them one by one and it's very tiresome; so I am wondering if there is a away to extract the urls from all of them at once?
<...
1
vote
0
answers
216
views
Excel - copy text from url to cell
I've got an excelsheet containing url's like so:
| column A | column B |
---------------------------------------------------
| www.example.com/page1 |
| www.example.com/...
1
vote
2
answers
6k
views
How do I extract a parameter within a URL in Excel?
I have the following URL in my Excel sheet rows:
www.test.com/folder1/?tagid=1234567
How do I extract the tagid value into a separate column so I simply have "1234567".
Thanks!
0
votes
1
answer
115
views
Mass change the appearance of URLs in Microsoft Excel
I wish to change the appearance of the URLS in a Microsoft Excel worksheet. At present the current URL's look something like: http://www.example.com/101010101010101010101010101. I know how to change ...
0
votes
1
answer
164
views
Hyperlinks in Cell Not Emplying Full Use of HTML
The following is on Excel 2013.
I have a spreadsheet that, through a VBA macro, takes a numerical input from a cell and appends it to a hyperlink to a PDF document on a website immediately after "#...
1
vote
1
answer
2k
views
file:// protocol in Excel and Word - Hyperlink URL changes
Clicking on file:///D:/UpToDate/contents/mobipreview.htm?3/4/3141 in Microsoft Excel opens an URL in a browser but omits the file:/// and ?3/4/3141 portions from the hyperlink thus the resource doesn'...
12
votes
2
answers
15k
views
Can I modify Excel Online share URLs to open to a specific worksheet?
When I generate a share URL in Excel Online, it takes the following form:
https://onedrive.live.com/view.aspx?
resid=<DOCUMENT ID>&
ithint=file%2cxlsx&
app=Excel&
authkey=<...
1
vote
1
answer
1k
views
Unwanted space in URLS in Excel 2010
I have a list of 23000 URLs in an Excel sheet but these appear to have extra spaces in, therefore invalidating the urls.
I've tried a find and replace and excel doesn't recognise that there is an ...
1
vote
3
answers
2k
views
How would I resolve a large batch of redirect URLs?
I have a .csv file will 1000s of aliased/shortened links (such as bit.ly etc.). I need to find out where they redirect to. Is there a simple program that could complete this task?
0
votes
1
answer
2k
views
Using Excel to capture URL redirects
In Excel is it possible to have a list of URLs in column A and have a column B auto-populate with the URL of the page you get to if you click the link in Column A.
(I would like to audit all the 301/...
1
vote
2
answers
1k
views
Why does Excel try to open password-protected URL links itself instead of just giving to the browser?
I have links to secure sites inside Excel spreadsheets (currently 2010, but I'm pretty sure it's the same with Office 2007).
When I click on them, instead of just launching the system browser (...