Google Spreadsheet tricks

(link)

On y trouve les trucs suivants :

• =IMAGE(A2), where A2 must contain a valid URL



• =GOOGLETRANSLATE(A2, “en”,”it”)


• =SPLIT(A2; “;”)


• =hyperlink(“URL”,”Title”) =HYPERLINK(A2, B2)


• =DAYS360(A2,B2) with A2 and B2 containing dates