Excel可以将CSV中的网址解释为超链接吗? [英] Can Excel interpret the URLs in my CSV as hyperlinks?
本文介绍了Excel可以将CSV中的网址解释为超链接吗?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
Excel可以将CSV中的网址解释为超链接吗?如果是,如何?
解决方案
你可以做到这一点,并且Excel显示一个可点击的链接。在CSV文件中使用此格式:
= HYPERLINK(URL)
因此,CSV如下所示:
1 ,23.4,= HYPERLINK(http://www.google.com)
'm试图获得一些链接,用逗号在他们的工作正常,它看起来不像有一种方法来逃避他们,仍然有Excel使链接可点击。
有谁知道如何?
Can Excel interpret the URLs in my CSV as hyperlinks? If so, how?
解决方案You can actually do this and have Excel show a clickable link. Use this format in the CSV file:
=HYPERLINK("URL")
So the CSV would look like:
1,23.4,=HYPERLINK("http://www.google.com")
However, I'm trying to get some links with commas in them to work properly and it doesn't look like there's a way to escape them and still have Excel make the link clickable.
Does anyone know how?
这篇关于Excel可以将CSV中的网址解释为超链接吗?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文