MS Excel

Assume that 11024c50030 is stored in cell A1:

then you can put this formula in cell B1:

=LEFT(A1,5)&" "&MID(A1,6,1)&" "&RIGHT(A1,5)

you will see

11024 c 50030

in cell B1

If you want those values to be stored in 3 different cells, you can just put


11024 =LEFT(A1,5)


c =MID(A1,6,1)

50030 =RIGHT(A1,5)


I hope that helps.

如果 CELL 的值是規律的話, 可用 Philipwong326 的方法
但如不規則.....
e.g. A1 = 11024c50030
A2 = 123ccc4567
A3 = 1234567ccccc123
可參考以下公式:
B1 =LOOKUP(9E+100,--LEFT(A1,ROW($1:$100)))
C1 =MID(A1,LEN(B1)+1,LEN(A1)-LEN(B1)-LEN(D1))
D1 =LOOKUP(9E+100,--RIGHT(A1,ROW($1:$100)))

公式往下拉便可