Buongiorno, ho bisogno, inserendo, in una cella excel la lettera "M", che nella cella appaia "CM1"

%3CLINGO-SUB%20id%3D%22lingo-sub-2873150%22%20slang%3D%22en-US%22%3EBuongiorno%2C%20ho%20bisogno%2C%20inserendo%2C%20in%20una%20cella%20excel%20la%20lettera%20%22M%22%2C%20che%20nella%20cella%20appaia%20%22CM1%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2873150%22%20slang%3D%22en-US%22%3E%3CP%3EBuongiorno%2C%20ho%20bisogno%2C%20inserendo%2C%20in%20una%20cella%20excel%20la%20lettera%20%22M%22%2C%20che%20nella%20cella%20appaia%20%22CM1%22%2C%20e%20allo%20stesso%20modo%2C%20inserendo%20%22P%22%2C%20%22N%22%2C%20%22SN%22%2C%20%22R%22%3B%20compaiano%20altri%20codici.%20Potete%20aiutarmi%3F%20Grazie%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2873150%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2873173%22%20slang%3D%22en-US%22%3ERe%3A%20Buongiorno%2C%20ho%20bisogno%2C%20inserendo%2C%20in%20una%20cella%20excel%20la%20lettera%20%26amp%3Bquot%3BM%26amp%3Bquot%3B%2C%20che%20nella%20cella%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2873173%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1192900%22%20target%3D%22_blank%22%3E%40Nikola1969%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CH1%20id%3D%22toc-hId-1474947914%22%20id%3D%22toc-hId-1474947888%22%20id%3D%22toc-hId-1474947888%22%20id%3D%22toc-hId-1474947888%22%20id%3D%22toc-hId-1474947888%22%20id%3D%22toc-hId-1474947888%22%20id%3D%22toc-hId-1474947888%22%3E%3CSPAN%20class%3D%22%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_self%22%3E%3CFONT%20color%3D%22%230000FF%22%3E%3CU%3EWelcome%20to%20your%20Excel%20discussion%20space!%20%3C%2FU%3E%3C%2FFONT%3E%3C%2FA%3E%3C%2FSPAN%3E%3C%2FH1%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CP%3EIf%20you%E2%80%99re%20looking%20to%20ask%20a%20question%20or%20start%20a%20conversation%20about%20Excel%2C%20you%E2%80%99re%20in%20the%20right%20place!%26nbsp%3B%20Ask%20away.%3C%2FP%3E%3CP%3EPlease%20include%20your%20%3CSTRONG%3EExcel%20version%3C%2FSTRONG%3E%2C%20%3CSTRONG%3Esample%20file%3C%2FSTRONG%3E%2C%20and%20a%20bit%20of%20%3CSTRONG%3Econtext%3C%2FSTRONG%3E%20to%20help%20others%20answer%20your%20question%2C%20for%20more%20infos%20click%20on%20the%20upper%20link.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolinoDE%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2873189%22%20slang%3D%22en-US%22%3ERe%3A%20Buongiorno%2C%20ho%20bisogno%2C%20inserendo%2C%20in%20una%20cella%20excel%20la%20lettera%20%26amp%3Bquot%3BM%26amp%3Bquot%3B%2C%20che%20nell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2873189%22%20slang%3D%22en-US%22%3EQuando%20scrivo%20%22M%22%20deve%20diventare%20%22CM1%22%3CBR%20%2F%3EQuando%20scrivo%20%22P%22%20deve%20diventare%20%22CP1%22%3CBR%20%2F%3EQuando%20scrivo%20%22N%22%20deve%20diventare%20%22CN1%22%3CBR%20%2F%3EQuando%20scrivo%20%22SN%22%20deve%20diventare%20%22SN1%22%3CBR%20%2F%3EQuando%20scrivo%20%22R%22%20deve%20diventare%20%22CR1%22%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Buongiorno, ho bisogno, inserendo, in una cella excel la lettera "M", che nella cella appaia "CM1", e allo stesso modo, inserendo "P", "N", "SN", "R"; compaiano altri codici. Potete aiutarmi? Grazie

7 Replies

@Nikola1969 

If you’re looking to ask a question or start a conversation about Excel, you’re in the right place!  Ask away.

Please include your Excel version, sample file, and a bit of context to help others answer your question, for more infos click on the upper link.

 

Thank you for your understanding and patience

 

NikolinoDE

I know I don't know anything (Socrates)

 

Quando scrivo "M" deve diventare "CM1"
Quando scrivo "P" deve diventare "CP1"
Quando scrivo "N" deve diventare "CN1"
Quando scrivo "SN" deve diventare "SN1"
Quando scrivo "R" deve diventare "CR1"
=SE(A1="M";"CM1";"")

in English:
=IF(A1="M","CM1","")

@NikolinoDE 

Buongiorno,

nulla, non riesco a far funzionare la formula.

 

@Nikola1969 

mmm... non so se è in italiano”; "È sostituito da", ", forse anche sostituire le virgolette (a seconda del formato della tastiera può portare a un problema). Sostituiscilo e riprova, la formula è già corretta ... ecco un esempio con la formula nel file inserito, copia la formula dalla cella e incollala nel tuo file.

 

Si prega di non dimenticare che il testo è tradotto automaticamente e che potrebbe portare a traduzioni errate.

 

 

 

Grazie per la vostra pazienza e comprensione