SOLVED
Home

due virgole nel dato

%3CLINGO-SUB%20id%3D%22lingo-sub-489020%22%20slang%3D%22en-US%22%3Edue%20virgole%20nel%20dato%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-489020%22%20slang%3D%22en-US%22%3E%3CP%3Eciao.%20scarico%20dei%20dati%20che%20hanno%20due%20virgole%3A%200%2C12%2C547.%3C%2FP%3E%3CP%3Evorrei%20creare%20una%20funzione%20che%20mi%20cancelli%20la%20seconda%20da%20sinistra%20(0%2C12547).%20ho%20provato%20con%20sostituisci%20inserendo%2C%20%23%2C%23%23%2C%23%23%23%20con%20%23%2C%23%23%23%23%23%2C%20non%20ho%20risolto%20nulla.%20grazie%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-489020%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-489292%22%20slang%3D%22en-US%22%3ERe%3A%20due%20virgole%20nel%20dato%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-489292%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F328743%22%20target%3D%22_blank%22%3E%40tradam_a%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEnglish%20one%3C%2FP%3E%0A%3CPRE%3E%3DSUBSTITUTE(A1%2C%22%2C%22%2C%22%22%2C2)%3C%2FPRE%3E%0A%3CP%3Eand%20I%20guess%20Italian%3C%2FP%3E%0A%3CPRE%3E%3DSOSTITUISCI(A1%3B%22%2C%22%3B%22%22%3B2)%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-490429%22%20slang%3D%22en-US%22%3ERe%3A%20due%20virgole%20nel%20dato%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-490429%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%3C%2FP%3E%3CP%3Egrazie%20della%20risposta.%20ho%20provato%2C%20ma%20non%20funziona%20bene.%3C%2FP%3E%3CP%3Eripeto%20la%20domanda%3A%20vorrei%20togliere%20la%20seconda%20virgola%20dal%20dato%20scaricato%3A%26nbsp%3B%3CSTRONG%3E0%2C12%2C547.%20%3C%2FSTRONG%3Eil%20risultato%20voluto%20dovrebbe%20essere%26nbsp%3B%3CSTRONG%3E0%2C12547.%3C%2FSTRONG%3E%20grazie%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-490807%22%20slang%3D%22en-US%22%3ERe%3A%20due%20virgole%20nel%20dato%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-490807%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F328743%22%20target%3D%22_blank%22%3E%40tradam_a%3C%2FA%3E%26nbsp%3B%2C%20please%20check%20attached%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-498102%22%20slang%3D%22en-US%22%3ERe%3A%20due%20virgole%20nel%20dato%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-498102%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20200px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F110912iF6E3F2AF7395D33E%2Fimage-size%2Fsmall%3Fv%3D1.0%26amp%3Bpx%3D200%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%3C%2FP%3E%3CP%3EC'%C3%A8%20qualcosa%20che%20non%20va%20nella%20formula!%20cmq%20grazie%20delle%20risposte%20e%20dei%20consigli.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-498124%22%20slang%3D%22en-US%22%3ERe%3A%20due%20virgole%20nel%20dato%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-498124%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%3C%2FP%3E%3CP%3Eall%20ok%2C%20thank%20you%20very%20much%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
tradam_a
Occasional Contributor

ciao. scarico dei dati che hanno due virgole: 0,12,547.

vorrei creare una funzione che mi cancelli la seconda da sinistra (0,12547). ho provato con sostituisci inserendo, #,##,### con #,#####, non ho risolto nulla. grazie

5 Replies

@tradam_a ,

 

English one

=SUBSTITUTE(A1,",","",2)

and I guess Italian

=SOSTITUISCI(A1;",";"";2)

 

@Sergei Baklan

grazie della risposta. ho provato, ma non funziona bene.

ripeto la domanda: vorrei togliere la seconda virgola dal dato scaricato: 0,12,547. il risultato voluto dovrebbe essere 0,12547. grazie 

@tradam_a , please check attached

Solution

image.png

@Sergei Baklan

C'è qualcosa che non va nella formula! cmq grazie delle risposte e dei consigli. 

@Sergei Baklan

all ok, thank you very much 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies