ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¦b«e5­Ó¼Æ¦r¤¤³Ì«á¤@­Ó¼Æ¦rªº«á­±ªÅ¤@­Ó

¦b«e5­Ó¼Æ¦r¤¤³Ì«á¤@­Ó¼Æ¦rªº«á­±ªÅ¤@­Ó

¦b«e5­Ó¼Æ¦r¤¤³Ì«á¤@­Ó¼Æ¦rªº«á­±ªÅ¤@­Ó
joyce

¦^´_ 1# leiru

¦bµª®×Äæ¦ì¥Î³o­Ó¤½¦¡
  1. =LEFT(A2,5)&" "&MID(A2,6,LEN(A2)-5)
½Æ»s¥N½X
¥Î¥\¨ì¥@¬É¥½¤é¨º¤@¤Ñ¡ã¡ã¡ã

TOP

=LEFT(A2,5)&" "&MID(A2,6,99)
=REPLACE(A2,6,," ")

TOP

°}¦C¤½¦¡¡G
=TRIM(REPLACE(A2,COUNT(-LEFT(A2,ROW($1:$9)))+1,," "))
¡@

83067°ª¶¯¥«»ñ¤s°Ï

83067 °ª¶¯¥«»ñ¤s°Ï

70259¥x«n¥««n°Ï

70259 ¥x«n¥««n°Ï

70049¥x«n¥««nªù¸ô

70049 ¥x«n¥««nªù¸ô

11470¥x¥_¥«¤º´ò°Ï«n¨ÊªF¸ô¤»¬q

11470 ¥x¥_¥«¤º´ò°Ï«n¨ÊªF¸ô¤»¬q

60041¹Å¸q¥«ªF°Ï¤¤¤s¸ô

60041 ¹Å¸q¥«ªF°Ï¤¤¤s¸ô

600¹Å¸q¥«ªF°Ï¤¤¤s¸ô

600 ¹Å¸q¥«ªF°Ï¤¤¤s¸ô

¹Å¸q¥«ªF°Ï¤¤¤s¸ô

¹Å¸q¥«ªF°Ï¤¤¤s¸ô

TOP

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

        ÀR«ä¦Û¦b : ¬°¤H³B¥@­n¤p¤ß²Ó¤ß¡A¦ý¤£­n¡u¤p¤ß²´¡v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD