How to replace text that repeats multiple times

[Flavien]

Hello,

Here's the type of formula I use. The words "NOMINAL_A"; "Appareil_A" are named cells.

I have to constantly add new conditions (because I forget some) and I have to redo Ctrl+H each time to redo the whole alphabet. Is there a code that allows me to change the combination "_B" as many times as there are letters? and thus generate a list with the 26 letters of the alphabet?

Thanks a lot for your help

[TABLE width="303pt"]
[TR]
[td width="404px"]SI(NOMINAL_B="";"";SI(Appareil_B="Tampon fileté";D1;SI(Appareil_B="Bague filetée";D1;SI(Appareil_B="Comparateur";"Comparateur";SI(Appareil_B="Keyence";"Programme N°"&D1;SI(Appareil_B="Micromètre";"Micromètre";SI(Appareil_B="Micro Pack";"Micro Pack";SI(Appareil_B="Pied à coulisse";"Pied à coulisse";Appareil_B&" "&Symb_B&Mini_B&" = Go"&" / "&Appareil_B&" "&Symb_B&Maxi_B&" = No Go"))))))))[/td]
[/TR]
[/TABLE]

 

[Peter_SSs]

Please

• Translate your formula to English (Excel Questions forum requires posting in English only), and
• Post your formula in the given formula code tags at the top of the Reply window only, not trying to to also use a table.

It may also help if you give some sample data, explain what you want in relation to that particular sample data and give the expected results. A good way is to use XL2BB
(If you have trouble with XL2BB, review the "XL2BB Icons greyed out" link in the 'Known XL2BB issues' section near the top of the XL2BB Instructions page linked above.)