劉任昌EXCEL函數LEFT,MID,RIGHT及PYTHON方法FIND
小於<大於>所謂的CSS就是和style相關的指令
小於<大於>指令是HTML
長度 (1) (2) (3)
地表最帥的人(1)賴清德(2)川普(3)劉德凱 23 7 13 18
=LEN(A2) =FIND("(1)",$A2) =FIND(H$1,$A2)
題目 (1) (2) (3)
EXCEL函數 LEFT MID MID RIGHT
取左邊 中間MIDDLE 取右邊
地表最帥的人 (1)賴清德 (2)川普 (3)劉德凱
=LEFT($A$2,F2-1) =MID($A$2,F2,G2-F2) =MID($A$2,G2,H2-G2) =RIGHT($A$2,E2-H2+1)
txt = '地表最帥的人(1)賴清德(2)川普(3)劉德凱'
#txt是字串string是字元character構成順序0,1,...
print(len(txt),'利用find方法接物件後面.')
print('(1)的位置',txt.find('(1)'))
print('(2)的位置',txt.find('(2)'))
print('(2)的位置',txt.find('(3)'))
print('最後-1',txt[-1])
print('第3到最後',txt[2:])
print('第2到5',txt[1:5])
for i in txt: print('迴圈一',i)
for i in range(len(txt)): print('迴圈二',i,txt[i])
https://chenyueying.blogspot.com/2026/09/1-2-3-123-lena2find1a2findh1a2-txt123.html
回覆刪除金融常識,順利執行
刪除https://huang-hsin-ju.blogspot.com/2026/09/excelleftmidrghtpythowfind.html
回覆刪除907,第一次上課,嵌入影片。https://huang-hsin-ju.blogspot.com/2026/09/blog-post.html
刪除https://yppp077.blogspot.com/2026/09/html-1-2-3-123-23-7-13-18-lena2-find1a2.html
回覆刪除https://kiannc1201.blogspot.com/2026/09/blog-post.html
回覆刪除https://chang-yun-yun.blogspot.com/2026/09/excelleftmidrightpythonfind.html
回覆刪除https://www.blogger.com/blog/post/edit/1636982424570868209/9088499216887808440?hl=zh-TW
回覆刪除https://kuozhehao.blogspot.com/2026/09/excelleftmidrightpythonfind.html
回覆刪除https://wangyuzhen.blogspot.com/2026/09/html-1-2-3-123-23-7-13-18-lena2-find1a2.html
回覆刪除https://hsu1214328.blogspot.com/2026/09/excelleftmidrightpythonfind.html
回覆刪除https://huang070207.blogspot.com/2026/09/excelleftmidrightpythonfind.html
回覆刪除https://ju890u56y77i.blogspot.com/2026/09/excelleftmidrightpythonfind.html
回覆刪除余展必須更改有意義的標題
刪除http://huangzhehui.blogspot.com/2026/09/excelleftmidrightpythonfind.html
回覆刪除https://changjiahul.blogspot.com/2026/09/excelleftmidrightpythonfind.html
回覆刪除https://www.blogger.com/blog/post/edit/preview/7935160905874122914/3647654134168420678
回覆刪除https://www.blogger.com/blog/post/edit/4970469280346467019/4884468157083999158
回覆刪除https://hsy08311111.blogspot.com/2026/09/excelleftmidrightpythonfind.html
回覆刪除https://zhonghexiao.blogspot.com/2026/09/excel.html
回覆刪除https://cynthia088.blogspot.com/2026/09/excelleftmidrightpythonfind.html
回覆刪除https://griuyijglkrijlrtfgfgf.blogspot.com/2026/09/excellfeftmidrightpythonfind.html
回覆刪除https://chinenkohana.blogspot.com/2026/09/excelleftmidright-pythonfnd.html
回覆刪除https://huangpeiling16.blogspot.com/2026/09/excelleftmidrightfind.html
回覆刪除https://ludingfeng.blogspot.com/2026/09/length-1-2-3-3.html
回覆刪除https://liushaouchi.blogspot.com/2026/09/excelleftmidrightpythonfind.html
回覆刪除嵌入embed影片、網頁,很完整。
刪除https://linhong01.blogspot.com/2026/09/excel02.html
回覆刪除尚未建立金融市場測驗網頁。
刪除https://www.blogger.com/blog/post/edit/4454713877152608989/1841603214035553795
回覆刪除https://dhyipgduwio3.blogspot.com/2026/09/excelleftmidrightpythonfind.html
回覆刪除https://wdwddq211223d.blogspot.com/2026/09/excelleftmidrightpythonfind.html
回覆刪除作者已經移除這則留言。
回覆刪除https://wei-chen-chang.blogspot.com/2026/09/excelleftmidrightpythonfind.html
回覆刪除https://wei-chen-chang.blogspot.com/2026/09/double-loopemoji.html
回覆刪除https://leexinni819.blogspot.com/2026/09/excelleftmidrightpythonfind.html
回覆刪除