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

[µo°Ý] Â^¨ú·Q­nªº¤å¦r¤º®evba

©T©w§R³Ì«á¢³¦r
=LEFT(A2,LEN(A2)-4)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

§R°£³Ì«á "-" ¥H«á¸ê®Æ
=LEFT(A2,LOOKUP(1,0/(MID(A2,ROW($1:$99),1)="-"),ROW($1:$99)-1))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¤Ó¶§¥ú¤j¡B¤÷¥À®¦¤j¡B§g¤l¶q¤j¡A¤p¤H®ð¤j¡C
ªð¦^¦Cªí ¤W¤@¥DÃD