samedi 27 juin 2020

How to copy text written with @ in excel

I have a formula for this -

  =CONCATENATE(IFERROR(TRIM(LEFT(SUBSTITUTE(MID(B4,FIND("~~",SUBSTITUTE(B4,"@","~~",1)),LEN(B4))," ",REPT(" ",100),1),100)),""),",",IFERROR(TRIM(LEFT(SUBSTITUTE(MID(B4,FIND("~~",SUBSTITUTE(B4,"@","~~",2)),LEN(B4))," ",REPT(" ",100),1),100)),""),",",IFERROR(TRIM(LEFT(SUBSTITUTE(MID(B4,FIND("~~",SUBSTITUTE(B4,"@","~~",3)),LEN(B4))," ",REPT(" ",100),1),100)),""))

But problem with this is that it only give results up to 3 words from a line with @ . For example if i have line - The @Sun is @beautiful and @only @star in the @solar system . This will give result - @sun @beautiful @only . But i want a formula so that i can extract all words with "@" from that line or paragraph . Please tell me if this is possible in excel or anyhow it is possible with another tool or any website




Aucun commentaire:

Enregistrer un commentaire