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

¦r¤¸¨ú¥N

=REPLACE(A1,4,3-LEN(MID(A1,4,2)*10),"-")
=REPLACE(A1,4,3,TEXT(MID(A1,4,3),"-#"))

145001STM¡@¡Ö¡@145-1STM
145012STM¡@¡Ö¡@145-12STM
145243STM¡@¡Ö¡@145-243STM

TOP

        ÀR«ä¦Û¦b : ¤f»¡¤@¥y¦n¸Ü¡A¦p¤f¥X½¬ªá¡F¤f»¡¤@¥yÃa¸Ü¦p¤f¦R¬r³D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD