[請問] excel 相同儲存格，英文數字分開:Realtime－派遣女醫x線上看派遣女醫x劇情派遣女醫x第2部派遣女醫x 線上派遣女醫x 2 派遣女醫x 2線上看派遣女醫x第二部派遣女醫x第2部線上看

Blogtrottr

批踢踢實業坊 ask 板

[請問] excel 相同儲存格，英文數字分開

Jan 10th 2015, 00:36, by STAR2599

作者STAR2599 (踏入OL的人生^^)

看板ask

標題[請問] excel 相同儲存格，英文數字分開

時間Sat Jan 10 00:36:46 2015

請問excel 儲存格j欄，同時有數字與英文字母，想把它們分開不同的儲存格，有什麼方式快又簡單學。處理這樣的狀況蠻多筆，謝謝。 -- Sent from my Android -- ※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 123.193.113.197 ※ 文章網址: http://www.ptt.cc/bbs/ask/M.1420821409.A.9D7.html

→ wxtab019: 你的英文數字是像abc123 還是a1b2c3這樣? 01/10 00:48

→ wxtab019: 或是數字在前 123abc 01/10 00:51

推 banqhsia: 格式一樣？資料剖析 01/10 01:00

This entry passed through the Full-Text RSS service - if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers.

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions