[問題] EXCEL資料更改
軟體:
EXCEL 2010
版本:
假設有數字一行
1632X3507233
1321X3507234
1686X3568253
想在隔壁一行
把前面數字去掉
換成
X3507233
X3507234
X3568253
這樣有什麼函數可打?
感謝感謝
.....Orz
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 59.126.27.219
→
12/22 21:41, , 1F
12/22 21:41, 1F
→
12/23 08:15, , 2F
12/23 08:15, 2F
推
12/23 08:34, , 3F
12/23 08:34, 3F
→
12/23 08:34, , 4F
12/23 08:34, 4F
→
12/23 08:36, , 5F
12/23 08:36, 5F
→
12/23 08:37, , 6F
12/23 08:37, 6F
→
12/24 21:04, , 7F
12/24 21:04, 7F
→
12/24 21:04, , 8F
12/24 21:04, 8F