姓名
=MID(A5,FIND("。",A5)+1,FIND("/",A5,FIND("/",A5)+1)-FIND("。",A5)-1)
電話
=MID(A5,FIND("/",A5,FIND("/",A5)+1)+1,FIND("/",A5,FIND("/",A5,FIND("/",A5)+1)+1)-FIND("/",A5,FIND("/",A5)+1)-1)
配送方式
=MID(A5,FIND("/",A5,FIND("/",A5,FIND("/",A5)+1)+1)+1,FIND("/",A5,FIND("/",A5,FIND("/",A5,FIND("/",A5)+1)+1)+1)-FIND("/",A5,FIND("/",A5,FIND("/",A5)+1)+1)-1)
日期 =MID(A5,FIND("/",A5,FIND("/",A5,FIND("/",A5,FIND("/",A5)+1)+1)+1)+1,FIND("午",A5)-FIND("/",A5,FIND("/",A5,FIND("/",A5,FIND("/",A5)+1)+1)+1)-2)
時間
=MID(A5,FIND("午",A5)-1,FIND("/",A5,FIND("/",A5,FIND("/",A5,FIND("/",A5,FIND("/",A5,FIND("/",A5)+1)+1)+1)+1)+1)-FIND("午",A5)+1)
市
=MID(A5,FIND("市",A5)-2,3)
區
=MID(A5,FIND("區",A5)-2,3)
地址
=RIGHT(A5,LEN(A5)-FIND("區",A5))
Excel Link
https://drive.google.com/file/d/0B382ZWkUR9OvMlh4SmYxNnR3MGc/view?usp=sharing
我用了找"/", "區", "市", 及上午下午的"午"的方法
如果格式上有變
或者第一句有以上的字,格式就會錯
你的格若不是A5
你CTRL+F 用FIND "A5" & REPLACE 你想要的格就可以