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

Excel ¨ú¯S®í¦r¤¸

=TRIM(RIGHT(SUBSTITUTE(A2,"+",REPT(" ",9)),9))

TOP

¦^´_ 3# jsc0518

=SUBSTITUTE(A2,"+",REPT(" ",9))
>> "3         L0000-29-ABC         PP"

"+"¥þÅܦ¨9­ÓªÅ¥Õ¦r¤¸, (­Y¦r¦êªø, ¥i§ï¦¨99)
¥k¨ú9­Ó¦r¤¸, ¦Atrim¥hªÅ¥Õ

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2019-1-2 18:46 ½s¿è

¦^´_ 6# jsc0518


¨º¬O³Ì²³æ¤S¦³®Ä²vªº¤èªk,
¤]¥i¸Õ¸Õ³o­Ó
=VLOOKUP("+*",RIGHT(A2,ROW($1:$19)),1,)  °}¦C¤½¦¡(¤TÁä¿é¤J)

©Î/¤@¯ë¤½¦¡:
=MID(A2,-LOOKUP(,-FIND("+",A2,ROW($1:$39))),9)

TOP

        ÀR«ä¦Û¦b : ¤£©È¨Æ¦h¡A¥u©È¦h¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD