よく使う関数

This entry was posted on
April 06 , 2017, Category is


=LEFT(C3,FIND(” “,C3)-1)
=RIGHT(C3,LEN(C3)-FIND(” “,C3))
=IF(T3<=11,”AM”,”PM”)
=IF(LEN(AC3)-LEN(SUBSTITUTE(AC3,”/”,))<2,”",TRIM(MID(SUBSTITUTE(AC3,”/”,REPT(” “,100)),100*2-99,100)))
=LEFT(AE3,FIND(“、image”,AE3)-1)
=MID(AE4,FIND(“image=”,AE4),FIND(“url=”,AE4)-FIND(“image=”,AE4)-1)

皆様の応援が次の記事を書く原動力です