如何在excel中批量添加后缀
怎么在excel中批量添加后缀HTML codenike-air-jordan-2010-whitenike-air-jordan-2010-gray-rednike-air-j
怎么在excel中批量添加后缀
HTML codenike-air-jordan-2010-whitenike-air-jordan-2010-gray-rednike-air-jordan-2010-black-greennike-air-jordan-2010-black-red-solenike-air-jordan-2010-red-and-blacknike-air-jordan-2010-red-blacknike-air-jordan-2010-red-white-bluenike-air-jordan-2010-white-black-rednike-air-jordan-2010-white-blue-rednike-air-jordan-2010-white-blue-yellow
想在每个数据后面批量添加.html。该怎么来操作
[解决办法]把上面的内容拷贝到A1中,在B1中写 =A1&".html",然后往下拉,下面的会自动添加.html。
nike-air-jordan-2010-white.html
nike-air-jordan-2010-gray-red.html
nike-air-jordan-2010-black-green.html
nike-air-jordan-2010-black-red-sole.html
nike-air-jordan-2010-red-and-black.html
nike-air-jordan-2010-red-black.html
nike-air-jordan-2010-red-white-blue.html
nike-air-jordan-2010-white-black-red.html
nike-air-jordan-2010-white-blue-red.html
nike-air-jordan-2010-white-blue-yellow.html