Excel编辑数据常用技巧记录

1.列数据组合用。
=L1&”, “&M1&”, “&N1&”, “&O1&”, “&P1&”, “&Q1&”, “&R1&”, “&S1&”, “&T1&”, “&U1

实例内容组合:
=”online store supply product “&D2&” price “&F2&”,cheaper than before,good deal for you.product SKU ID:”&B2&””

发表回复

您的电子邮箱地址不会被公开。 必填项已用*标注