added this to cell h1. ={"LINK";Arrayformula(If(B2:B="",,hyperlink("www.google.com/search?q="&B2:B&" pronunciation",B2:B)))}.
確定! 回上一頁