如何替换单元格中的网址

ALLzjc · 发表于 2021-11-9 19:51

举例单元格A1的内容为
A0 to A3 in MEGA are PORTF <a href="https//www.theengineeringprojects.com/wp-content/uploads/2021/01/introduction-to-arduino-mega-2560-rev3.png</a>
单元格A2的内容为
I see in your other Instructable https://www.instructables.com/id ... ded-Chi/step7/Cool/ you mention rubbing it and the image labeled Coarse Rubbing looks like the real thing. Why didn't you do that here?

问题：如何把上述A1中的<a href="https//www.theengineeringprojects.com/wp-content/uploads/2021/01/introduction-to-arduino-mega-2560-rev3.png</a>整个替换为一个单词“subURL”；A2中的https://www.instructables.com/id ... ded-Chi/step7/Cool/整个替换为一个单词“subURL”

jians0529 · 发表于 2021-11-10 15:06

如图可以找规律用通配符进行替换。。如有其它更多数据请压缩档案上传并说明规则！

ALLzjc · 发表于 2021-11-10 15:53

十分感谢！学到了~

		自动登录	找回密码
密码			免费注册

[求助] 如何替换单元格中的网址