[算表] 去除空白格
軟體:excel
版本:2003
請問一下要怎麼去除空白格??
例如
A B
1 Ny YesX Ny Yes
2 Ny NoX Ny No
上面大寫X是空白一格 ~
所以若我複製A時~ 文字最後會多一格空白X
現在我要在 B 去除空白
這樣我複製時就不會有那格空白
請問要怎麼寫??
感謝~
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 61.228.86.220
推
05/10 00:21, , 1F
05/10 00:21, 1F
→
05/10 00:23, , 2F
05/10 00:23, 2F
→
05/10 00:23, , 3F
05/10 00:23, 3F
→
05/10 00:24, , 4F
05/10 00:24, 4F
→
05/10 00:25, , 5F
05/10 00:25, 5F
→
05/10 00:29, , 6F
05/10 00:29, 6F
推
05/10 09:43, , 7F
05/10 09:43, 7F