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?

本文标签: