[問題] excel儲存格加入特殊符號
請問一下
我想在輸入好的excel表格內
每一個有值的儲存格都加入特殊符號
例如: 1 2 3 變成「1」「2」「3」
僅套用於有值的儲存格內
請問該如何處理呢?
是否要用到VBA?
麻煩了謝謝!
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 117.19.102.232
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1504582805.A.A05.html
推
09/05 11:51, , 1F
09/05 11:51, 1F
→
09/05 12:00, , 2F
09/05 12:00, 2F
→
09/05 12:02, , 3F
09/05 12:02, 3F
→
09/05 12:03, , 4F
09/05 12:03, 4F
→
09/05 13:43, , 5F
09/05 13:43, 5F
→
09/05 13:43, , 6F
09/05 13:43, 6F
→
09/05 14:03, , 7F
09/05 14:03, 7F
→
09/05 14:04, , 8F
09/05 14:04, 8F
→
09/05 14:06, , 9F
09/05 14:06, 9F
→
09/05 14:06, , 10F
09/05 14:06, 10F
→
09/05 14:14, , 11F
09/05 14:14, 11F
→
09/05 14:14, , 12F
09/05 14:14, 12F
→
09/05 14:14, , 13F
09/05 14:14, 13F
→
09/05 14:51, , 14F
09/05 14:51, 14F
→
09/05 14:51, , 15F
09/05 14:51, 15F
→
09/05 14:51, , 16F
09/05 14:51, 16F