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

[µo°Ý] ½Ð°Ý¦p¦óÂ^¨ú·Q­nªº¤å¦r¤º®e

[µo°Ý] ½Ð°Ý¦p¦óÂ^¨ú·Q­nªº¤å¦r¤º®e

¦U¦ì¥ý¶i¤j®a¦n~
¤p§Ì¤£¤~,·Q½Ð°Ý
¨Ò¦pA1¤º®e¬O«È+4.5, 1.75
§Ú¥u·Q­nÂ^¨ú«á­±1.75³o¤T­Ó¼Æ¦r
§Ú¿é¤J=MID(A1,2,4)
¦pªGA2¤º®e¬O«È+10.5, 1.75
§Ú¥u·Q­nÂ^¨ú«á­±1.75³o¤T­Ó¼Æ¦r
¦³¬Æ»ò«ü¥O¥i¥H¦P®ÉÅýEXCEL§PÂ_§Ú¥u­n«á­±1.75³o­Ó¼Æ¦r??

·PÁÂ#ikboy #rouber590324 ªº±Ð¾É~¤p§Ì¨ü¥ÎµL½a~

TOP

SEARCH-¤£°Ï¤À¤j¤p¼g
FIND- ·|°Ï§O¤j¤p¼g¡A¦Ó¥B¤]¤£¤¹³\¨Ï¥Î¸U¥Î¦r¤¸¡C

=MID(A1,1,SEARCH(",",A1)-1)
ù

TOP

§ä¨§¸¹¥ªÃä =MID(A1,1,FIND(",",A1)-1)
§ä¨§¸¹¥kÃä =MID(A1,FIND(",",A1)+1,99)

TOP

#rouber590324

¤£¦n·N«ä~¤p§Ì·Q°Ýªº¸ò§Ú¼gªº¦³¸¨®t
À³¸Ó¬O³o¼Ëªí¹F·|¤ñ¸û¦n~
¨Ò¦pA1¤º®e¬O«È+4.5, 1.75
§Ú¥u·Q­nÂ^¨ú«e­±«È+4.5³o¤­­Ó¦r
¦³®ÉA1¤º®e¬O«È+10.5, 1.75
§Ú¥u·Q­nÂ^¨ú«e­±«È+10.5³o¤»­Ó¼Æ¦r
A1·|¤£¤@©wªº¥X²{«È+4.5,1.75©Î¬O«È+10.5,1.75
¤p§Ì·Q­nªº¬O«È+4.5¸ò«È+10.5
³oºØ¤½¦¡¸Ó¦p¦ó¤U©O??

TOP

¦^´_ 2# rouber590324


·PÁ±z~

½Ð°Ý¦pªG¥u­n¤º®e¬O«È+4.5, 1.75
§Ú¥u·Q­nÂ^¨ú«e­±­±+4.5³o¥|­Ó¦r

¦pªGA2¤º®e¬O«È+10.5, 1.75
§Ú¥u·Q­nÂ^¨ú«e­±+10.5³o¤­­Ó¦r

TOP

=MID(A1,SEARCH(",",A1)+1,LEN(A1)-SEARCH(",",A1))
ù

TOP

        ÀR«ä¦Û¦b : ¦n¨Æ­n´£±o°_¡A¬O«D­n©ñ±o¤U¡A¦¨´N§O¤H§Y¬O¦¨´N¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD