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

½Ð°Ý¦p¦óÅý¼Ð·Ç¸ò¤£¼Ð·Çªººô§},¥Î¨ç¼Æ¤@°_Åܦ¨¼Ð·Çªººô§}?

½Ð°Ý¦p¦óÅý¼Ð·Ç¸ò¤£¼Ð·Çªººô§},¥Î¨ç¼Æ¤@°_Åܦ¨¼Ð·Çªººô§}?

¦]¬°¸ê®Æ¥Î¶×¤Jªº,¼Æ¶q«Ü¦h,¤£·Q¥Î¤â°Êªº

¦pA1~A5
www.cpdc.com.tw
http://www.upc.com.tw
http://www.gppc.com.tw
www.usife.com.tw
WWW.TYG.COM.TW

¦bB1~B5³q³qÅܦ¨¼Ð·Ç®æ¦¡
http://www.cpdc.com.tw
http://www.upc.com.tw
http://www.gppc.com.tw
http://www.usife.com.tw
http://WWW.TYG.COM.TW

·PÁÂ!

¦^´_ 1# eric866

=IF(ISERROR(FIND("http://www.",A1)),"http://"&A1,A1)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ eric866 ©ó 2017-9-4 14:41 ½s¿è

²{¦b¦b¥~­± ¨S¦³EXCEL¸Õ ¥ýÁÂÁÂHsiehª©¥DÅo!
³o¸Ì¯u¦n!

TOP

¦^´_ 2# Hsieh


¸Õ¹L¤F~¥i¥H!
«D±`·PÁÂ! ¦Û¤v·Q¯}ÀY¤]·Q¤£¥X¨Ó!

TOP

=IF(LEFT(A1,4)="www.","http://",)&A1
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

=IF(LEFT(A1,4)="www.","http://",)&A1

²Î¤@§ï¬° ¤p¼g
=IF(LEFT(A1,4)="www.","http://",)&LOWER(A1)

²Î¤@§ï¬° ¤j¼g
=IF(LEFT(A1,4)="www.","HTTP://",)&UPPER(A1)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 6# ML089


¤]ÁÂÁ§Aªº¦^µª~¸Õ¤F¤]¥i¥H!

TOP

        ÀR«ä¦Û¦b : ¶¢¤HµL¼Ö½ì¡A¦£¤HµL¬O«D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD