EXCEL中批量添加文件夹超链接

2025-02-24 10:25:04
推荐回答(1个)
回答1:

=HYPERLINK(SUBSTITUTE("C:/资料/FD111","111",RIGHT("000"&ROW(),3)),SUBSTITUTE("FD111","111",RIGHT("000"&ROW(),3)))