SOLVED

Fonctions, suggestion pour modifier

%3CLINGO-SUB%20id%3D%22lingo-sub-2510943%22%20slang%3D%22fr-FR%22%3EFunctions%2C%20suggestion%20to%20edit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2510943%22%20slang%3D%22fr-FR%22%3E%3CP%3EGood%20morning%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20change%20my%20formula%20so%20that%20all%20%22001%22%20instances%20are%20replaced%20by%20%226-5-1G-Page%22%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2510943%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2511053%22%20slang%3D%22en-US%22%3ERe%3A%20Fonctions%2C%20suggestion%20pour%20modifier%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2511053%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F703787%22%20target%3D%22_blank%22%3E%40WorrypasCanada%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DSUBSTITUTE(B1%2C%22001%22%2CA3)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eou%20bien%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DSUBSTITUE(B1%3B%22001%22%3BA3)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2511271%22%20slang%3D%22fr-FR%22%3ERe%3A%20Functions%2C%20suggestion%20to%20edit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2511271%22%20slang%3D%22fr-FR%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3EVogelaar%20%40Hans%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%20and%20sorry%20for%20the%20lack%20of%20precision.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20data%20in%20column%20A%20shall%20replace%20%22001%22%20in%20column%20B.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eoriginal%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%221103%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22118%22%3Eoriginal%3C%2FTD%3E%3CTD%20width%3D%22985%22%3Edir%20%2Fs%20%2Fb%20%22C%3A%5CRobert-Richard%5CTesseract%5CEntree%5C001%22%20%7C%20tesseract.exe%20-c%20stream_filelist%3Dtrue%20-%20-%20pdf%20%26gt%3B%20%22C%3A%5CRobert-Richard%5CTesseract%5CSortie%5C001.pdf%22%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%221103%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22118%22%3E6-5-1G-Page%3C%2FTD%3E%3CTD%20width%3D%22985%22%3Edir%20%2Fs%20%2Fb%20%22C%3A%5CRobert-Richard%5CTesseract%5CEntree%5C6-5-1G-Page%22%20%7C%20tesseract.exe%20-c%20stream_filelist%3Dtrue%20-%20-%20pdf%20%26gt%3B%20%22C%3A%5CRobert-Richard%5CTesseract%5CSortie%5C6-5-1G-Page.pdf%22%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E6-6-1-Page%3C%2FTD%3E%3CTD%3Edir%20%2Fs%20%2Fb%20%22C%3A%5CRobert-Richard%5CTesseract%5CEntree%5C6-6-1-Page%22%20%7C%20tesseract.exe%20-c%20stream_filelist%3Dtrue%20-%20-%20pdf%20%26gt%3B%20%22C%3A%5CRobert-Richard%5CTesseract%5CSortie%5C6-6-1-Page.pdf%22%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E6-2-2-Page%3C%2FTD%3E%3CTD%3Edir%20%2Fs%20%2Fb%20%22C%3A%5CRobert-Richard%5CTesseract%5CEntree%5C6-2-2-Page%22%20%7C%20tesseract.exe%20-c%20stream_filelist%3Dtrue%20-%20-%20pdf%20%26gt%3B%20%22C%3A%5CRobert-Richard%5CTesseract%5CSortie%5C6-2-2-Page.pdf%22%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E6-10-2-Page%3C%2FTD%3E%3CTD%3Edir%20%2Fs%20%2Fb%20%22C%3A%5CRobert-Richard%5CTesseract%5CEntree%5C6-10-2-Page%22%20%7C%20tesseract.exe%20-c%20stream_filelist%3Dtrue%20-%20-%20pdf%20%26gt%3B%20%22C%3A%5CRobert-Richard%5CTesseract%5CSortie%5C6-10-2-Page.pdf%22%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E6-5-1C-Page%3C%2FTD%3E%3CTD%3Edir%20%2Fs%20%2Fb%20%22C%3A%5CRobert-Richard%5CTesseract%5CEntree%5C6-5-1C-Page%22%20%7C%20tesseract.exe%20-c%20stream_filelist%3Dtrue%20-%20-%20pdf%20%26gt%3B%20%22C%3A%5CRobert-Richard%5CTesseract%5CSortie%5C6-5-1C-Page.pdf%22%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E6-4-1-Page%3C%2FTD%3E%3CTD%3Edir%20%2Fs%20%2Fb%20%22C%3A%5CRobert-Richard%5CTesseract%5CEntree%5C6-4-1-Page%22%20%7C%20tesseract.exe%20-c%20stream_filelist%3Dtrue%20-%20-%20pdf%20%26gt%3B%20%22C%3A%5CRobert-Richard%5CTesseract%5CSortie%5C6-4-1-Page.pdf%22%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2511744%22%20slang%3D%22en-US%22%3ERe%3A%20Fonctions%2C%20suggestion%20pour%20modifier%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2511744%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F703787%22%20target%3D%22_blank%22%3E%40WorrypasCanada%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDans%20B3%3A%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DSUBSTITUTE(B%241%2C%22001%22%2CA3)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3ERemplir%20ou%20copier%20vers%20le%20bas.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Bonjour,

 

Comment modifier ma formule pour que toutes les instances "001" soit remplacer "6-5-1G-Page" ?

 

Merci.

6 Replies

@WorrypasCanada 

 

=SUBSTITUTE(B1,"001",A3)

 

ou bien

 

=SUBSTITUE(B1;"001";A3)

@Hans Vogelaar 

 

Merci, et désolé pour le manque de précision.

 

La donnée dans la colonne A doit remplacer "001" de la colonne B.

 

Remerciements.

 

Original :

 

Originaldir /s /b "C:\Robert-Richard\Tesseract\Entree\001" | tesseract.exe -c stream_filelist=true - - pdf > "C:\Robert-Richard\Tesseract\Sortie\001.pdf"

 

6-5-1G-Pagedir /s /b "C:\Robert-Richard\Tesseract\Entree\6-5-1G-Page" | tesseract.exe -c stream_filelist=true - - pdf > "C:\Robert-Richard\Tesseract\Sortie\6-5-1G-Page.pdf"
6-6-1-Pagedir /s /b "C:\Robert-Richard\Tesseract\Entree\6-6-1-Page" | tesseract.exe -c stream_filelist=true - - pdf > "C:\Robert-Richard\Tesseract\Sortie\6-6-1-Page.pdf"
6-2-2-Pagedir /s /b "C:\Robert-Richard\Tesseract\Entree\6-2-2-Page" | tesseract.exe -c stream_filelist=true - - pdf > "C:\Robert-Richard\Tesseract\Sortie\6-2-2-Page.pdf"
6-10-2-Pagedir /s /b "C:\Robert-Richard\Tesseract\Entree\6-10-2-Page" | tesseract.exe -c stream_filelist=true - - pdf > "C:\Robert-Richard\Tesseract\Sortie\6-10-2-Page.pdf"
6-5-1C-Pagedir /s /b "C:\Robert-Richard\Tesseract\Entree\6-5-1C-Page" | tesseract.exe -c stream_filelist=true - - pdf > "C:\Robert-Richard\Tesseract\Sortie\6-5-1C-Page.pdf"
6-4-1-Pagedir /s /b "C:\Robert-Richard\Tesseract\Entree\6-4-1-Page" | tesseract.exe -c stream_filelist=true - - pdf > "C:\Robert-Richard\Tesseract\Sortie\6-4-1-Page.pdf"

@WorrypasCanada 

Dans B3:

=SUBSTITUTE(B$1,"001",A3)

Remplir ou copier vers le bas.

@Hans Vogelaar 

 

La dernière formule suggérée ne fonctionne pas.

 

=SUBSTITUTE(B$1,"001",A3)

 

Une erreur s'affiche, voir image annexée. J'utilise la version française d'Office 2016.

 

Merci, pour votre patience, et bon weekend

.

best response confirmed by allyreckerman (Microsoft)
Solution

@WorrypasCanada 

Voir le fichier attachée

@Hans Vogelaar 

 

Problème résolu.

 

merci !