B1: ="https://fr.wikipedia.org/wiki/"&ENCODEURL("Indiana Jones et le Royaume du crâne de cristal")
Output B1: https://fr.wikipedia.org/wiki/Indiana%20Jones%20et%20le%20Royaume%20du%20cr%C3%A2ne%20de%20cristal
B2: https://fr.wikipedia.org/wiki/Indiana_Jones_et_le_Royaume_du_cr%C3%A2ne_de_cristal
C2:
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B2,"%3F","?"),"%20"," "),"%25", "%"),"%26","&"),"%27","'"),"%2B","+"),"%2C",","),"%2D","-"),"%2E","."),"%3D","="),"%7B","{"),"%7D","}"),"%5B","["),"%5D","]"),"%5F","_"),"%3A",":"),"%22",""""),"%C3%80","À"),"%C3%81","Á"),"%C3%82","Â"),"%C3%83","Ã"),"%C3%84","Ä"),"%C3%85","Å"),"%C3%86","Æ"),"%C3%87","Ç"),"%C3%88","È"),"%C3%89","É"),"%C3%8A","Ê"),"%C3%8B","Ë"),"%C3%8C","Ì"),"%C3%8D","Í"),"%C3%8E","Î"),"%C3%8F","Ï"),"%C3%91","Ñ"),"%C3%92","Ò"),"%C3%93","Ó"),"%C3%94","Ô"),"%C3%95","Õ"),"%C3%96","Ö"),"%C3%99","Ù"),"%C3%9A","Ú"),"%C3%9B","Û"),"%C3%9C","Ü"),"%C3%A0","à"),"%C3%A1","á"),"%C3%A2","â"),"%C3%A3","ã"),"%C3%A4","ä"),"%C3%A5","å"),"%C3%A6","æ"),"%C3%A7","ç"),"%C3%A8","è"),"%C3%A9","é"),"%C3%AA","ê"),"%C3%AB","ë"),"%C3%AC","ì"),"%C3%AD","í"),"%C3%AE","î"),"%C3%AF","ï"),"%C3%B1","ñ"),"%C3%B2","ò"),"%C3%B3","ó"),"%C3%B4","ô"),"%C3%B5","õ"),"%C3%B6","ö"),"%C3%B9","ù"),"%C3%BA","ú"),"%C3%BB","û"),"%C3%BC","ü"),"%C5%93","œ"),"%E2%80%93","–")
Output C2 = https://fr.wikipedia.org/wiki/Indiana_Jones_et_le_Royaume_du_crâne_de_cristal
D2: =substitute(substitute(substitute(substitute(mid(C2,31,256),"_"," ")," film)",")"),"(film, ","(")," (film)","")
Output D2: Indiana Jones et le Royaume du crâne de cristal
![image](https://private-user-images.githubusercontent.com/64386272/285668488-006322f4-8bb5-4204-8e03-fca0ada8a4df.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjE4MTk2NjUsIm5iZiI6MTcyMTgxOTM2NSwicGF0aCI6Ii82NDM4NjI3Mi8yODU2Njg0ODgtMDA2MzIyZjQtOGJiNS00MjA0LThlMDMtZmNhMGFkYThhNGRmLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA3MjQlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwNzI0VDExMDkyNVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTNhNzQyNjlkODI3OGIyNTI5YmFjNzhkZDAwY2M2MjNmODI1MjY1ODFjZTgzMGZjZGRkZjA5ZTBhZDY3NTM3OGImWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.swLjVmjdhwJj0TJmW8bnjESTDMajAV3mB-Mjzntutsk)
First formula try
=SERIESSUM(2,0,-1,{210000*50,210000*50,210000*50,210000*50,210000*50,210000*50,210000*50,210000*50,210000*50,210000*50,210000*50,210000*50,210000*50,210000*50,210000*50,210000*50,210000*50,210000*50,210000*50,210000*50,210000*50,210000*50,210000*50,210000*50,210000*50,210000*50,210000*50,210000*50,210000*50,210000*50,210000*50,210000*50,210000*50})
Best optimization after some iterations
=SERIESSUM(2,0,-1,SEQUENCE(33, 1, 210000*50, 0))
Output = 20,999,999.9975553