Excel 求助一个我向厂家下订单的表格
发布网友
发布时间：2022-04-22 18:29
共1个回答
热心网友
时间：2023-05-23 18:29
示意图如下：在C1中输入公式：=IF(LEN($A1)<COLUMN(A1),"",LOOKUP(MID($A1,COLUMN(A$1),1),{"1","2","3","4","5","6","7","8","9"},{"A","A","A","B","B","B","C","C","C"}))，公式下拉右拉。 选取单元格区域C1：L10，点“复制”，选取单元格N1，点“选择性粘贴”--“粘贴值”，在Y3中输入公式：=PHONETIC(N1:W1) ，公式下拉。
