我在谷歌表格中有這樣的字串：
在 A1
,information-technology#ICT / Computer
在 A2
,agriculture#Agriculture / Agro-Allied,ngo#NGO/Non-Profit,project-management#Project Management
我需要洗掉以包括這兩個字符開頭,和結尾的所有內容#
如果可能，輸出用逗號分隔，如下所示
B1
ICT / Computer
B2
Agriculture / Agro-Allied, NGO/Non-Profit, Project Management
uj5u.com熱心網友回復：
嘗試：
=ARRAYFORMULA(REGEXREPLACE(TRIM(FLATTEN(QUERY(
TRANSPOSE(IF(IFERROR(SPLIT(A1:A3, "#"))<>"",
REGEXREPLACE(SPLIT(REGEXREPLACE(A1:A3, "(#)", "$1?"),
"?"), "(,. )", )&",", )),,9^9))), "^, |,$", ))
轉載請註明出處，本文鏈接：https://www.uj5u.com/ruanti/475171.html