当前位置: 代码迷 >> Office >> 如何在excel中批量添加后缀
  详细解决方案

如何在excel中批量添加后缀

热度:1271   发布时间:2013-02-26 00:00:00.0
怎么在excel中批量添加后缀
HTML code
nike-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


想在每个数据后面批量添加。该怎么来操作

------解决方案--------------------------------------------------------
把上面的内容拷贝到A1中,在B1中写 =A1&"",然后往下拉,下面的会自动添加。
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
  相关解决方案