如何在excel中批量添加后缀

怎么在excel中批量添加后缀

HTML code

nike-air-jordan-2010-white
nike-air-jordan-2010-gray-red
nike-air-jordan-2010-black-green
nike-air-jordan-2010-black-red-sole
nike-air-jordan-2010-red-and-black
nike-air-jordan-2010-red-black
nike-air-jordan-2010-red-white-blue
nike-air-jordan-2010-white-black-red
nike-air-jordan-2010-white-blue-red
nike-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