admin管理员组文章数量:1390571
I have to import a .csv to my website to create a table. The table should have the following cells in one row...
[Model] [Name] [PDF + file link] [IES + file link] [LDT + file link]
For the links I want the text to be PDF, IES, LDT. Each of these need to be linked to a file on the website (.pdf).
I know how to use =Hyperlink
and have a file with that setup but it is a .xls file. My formula is =HYPERLINK(Sheet1!A2, "PDF")
.
I refer to a different sheet because the link can't be in the .csv file or it will show up in the table on my site. The import is very strict with the software I am using (Elementor). Basically the table I have in the .csv shows in an un-editable table on the page.
The problem I have is that if I save the sheet with the formula to a .csv the hyperlink formula breaks and I just get the text (i.e. PDF + no link). When importing, I then don't have the link to the file with the text.
What I need to do is find a way to convert that hyperlink formula to text that will keep the link within a .csv (which uses only 1 sheet).
Any ideas?
本文标签:
版权声明:本文标题:excel - How can I create a CSV with hyperlinked text that uses another cell to populate the link? - Stack Overflow 内容由网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:http://www.betaflare.com/web/1744732999a2622156.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论