[µo°Ý] Àx¦s®æ¤º®eªÅ¥Õ¦p¦ó¦Û°Ê¥h°£

rouber590324

DEAR  ALL ¤j¤j
1. ¨Ò Àx¦s®æ¤º®e=520 (10.2¡Ñ 11mm)  
1.1 ¦³2ªÅ®æ
2.¦p¦ó±NÀx¦s®æ¤º®eªÅ¥Õ¦Û°Ê¥h°£Åܬ° 520(10.2¡Ñ11mm)
2.1 ¨Ï¥Î  TRIM µ²ªGÁÙ¬O¨q¥X   520 (10.2¡Ñ 11mm)
3.·Ð¤£§[½ç±Ð    THANKS*10000

naruto018

¦^´_ 1# rouber590324

=SUBSTITUTE(A1," ","")

²Â¤p«Ä

¦^´_  rouber590324

=SUBSTITUTE(A1," ","")
naruto018 µoªí©ó 2018-7-24 10:48

SUBSTITUTE(SUBSTITUTE(A1,"0"," "),"-"," ")
01-02-10»Ý¨D1 2 10¦ý¶Ç¦^1 2 1
09-10-11»Ý¨D9 10 11¦ý¶Ç¦^9 1 11
10-11-12»Ý¨D10 11 12¦ý¶Ç¦^1 11 12
¶Ç¦^¤£§¹¾ã·Q¤£³q«ç¸Ñ¨M³o°ÝÃD¡C

rouber590324

DEAR naruto018 ¤j¤j  
  THANKS*10000 ¤@»yÅå¿ô¹Ú¤¤¤H

naruto018

¦^´_ 3# ²Â¤p«Ä


    =SUBSTITUTE(SUBSTITUTE(IF(LEFT(A1,1)="0",RIGHT(A1,LEN(A1)-1),A1),"-0","-"),"-"," ")

²Â¤p«Ä

¦^´_ 5# naruto018
´bÁ¦Ѯv¡A»s§@¤S½ñ«e¤@¨B¡C

­ã´£³¡ªL

¦^´_ 3# ²Â¤p«Ä


=MID(SUBSTITUTE("-"&A1,"-0","-"),2,99)

²Â¤p«Ä

¦^´_ 6# ²Â¤p«Ä
·PÁ¦Ѯv¡A»s§@¤S½ñ«e¤@¨B¡C