[算表] 如何蒐尋字串並找到符合的文字並呈現出
軟體:EXCEL
版本:2016
問題敘述
請問一下 如何在固定的欄位中，搜尋到我需要的字串，符合字串並呈現該字串
備註 會有多字串選擇判斷不分大小寫
如下
Canon PIXMA PRO-10 A3+專業噴墨相片印表機 Canon
EPSON WorkForce WF-100 A4 彩色噴墨行動印表機 EPSON
BROTHER HL-1110黑白雷射印表機 BROTHER
請大神幫忙謝謝
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 118.163.88.127
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1477133078.A.D1B.html
→
10/22 18:59, , 1F
10/22 18:59, 1F
→
10/22 19:00, , 2F
10/22 19:00, 2F
→
10/22 19:01, , 3F
10/22 19:01, 3F
→
10/22 19:06, , 4F
10/22 19:06, 4F
→
10/22 19:10, , 5F
10/22 19:10, 5F
→
10/22 20:32, , 6F
10/22 20:32, 6F
→
10/22 20:33, , 7F
10/22 20:33, 7F
→
10/22 20:37, , 8F
10/22 20:37, 8F
→
10/22 20:50, , 9F
10/22 20:50, 9F
→
10/22 20:51, , 10F
10/22 20:51, 10F
→
10/22 21:36, , 11F
10/22 21:36, 11F
→
10/22 21:56, , 12F
10/22 21:56, 12F
→
10/22 22:02, , 13F
10/22 22:02, 13F
→
10/22 22:02, , 14F
10/22 22:02, 14F
→
10/22 22:06, , 15F
10/22 22:06, 15F
→
10/22 22:13, , 16F
10/22 22:13, 16F
→
10/22 22:15, , 17F
10/22 22:15, 17F
→
10/22 22:18, , 18F
10/22 22:18, 18F
→
10/22 22:19, , 19F
10/22 22:19, 19F
→
10/22 22:27, , 20F
10/22 22:27, 20F
→
10/22 22:39, , 21F
10/22 22:39, 21F
→
10/22 22:40, , 22F
10/22 22:40, 22F
→
10/22 22:40, , 23F
10/22 22:40, 23F
→
10/23 18:36, , 24F
10/23 18:36, 24F
→
10/23 18:38, , 25F
10/23 18:38, 25F
→
10/23 18:38, , 26F
10/23 18:38, 26F
→
10/23 21:23, , 27F
10/23 21:23, 27F
→
10/23 23:00, , 28F
10/23 23:00, 28F
→
10/23 23:12, , 29F
10/23 23:12, 29F
→
10/23 23:12, , 30F
10/23 23:12, 30F
→
10/23 23:35, , 31F
10/23 23:35, 31F
→
10/23 23:35, , 32F
10/23 23:35, 32F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
