SOLVED

find string if not matches replace this to character string

%3CLINGO-SUB%20id%3D%22lingo-sub-3026410%22%20slang%3D%22en-US%22%3Efind%20string%20if%20not%20matches%20replace%20this%20to%20character%20string%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3026410%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Community%20can%20anyone%20help%20me%20to%20start%20with%20excel%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20check%20each%20cell%20of%20a%20row%20(%3CSTRONG%3EF%3AF%3C%2FSTRONG%3E)%20if%20it%20%3CSTRONG%3Enot%20matches%20with%20a%20string%3C%2FSTRONG%3E%20-%26gt%3B%22%3CSTRONG%3Ekeyword%3C%2FSTRONG%3E%22%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20then%20%3CSTRONG%3Ereplace%20each%20cell%26nbsp%3B%20%26nbsp%3Bwith%26nbsp%3B%20a%20string%20called%20-%26gt%3B%3C%2FSTRONG%3E%22%3CSTRONG%3Esomething%3C%2FSTRONG%3E%22%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%22t%20come%20closer%20to%20this%20goal%20allone.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Evba%20would%20be%20great%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much%20for%20your%20help%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3026410%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-3026828%22%20slang%3D%22en-US%22%3ERe%3A%20find%20string%20if%20not%20matches%20replace%20this%20to%20character%20string%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3026828%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1236196%22%20target%3D%22_blank%22%3E%40excelbaer1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(ISNUMBER(SEARCH(%22*%22%26amp%3BI%241%26amp%3B%22*%22%2CF1))%3DFALSE%2C%22something%22%2CF1)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20what%20you%20are%20looking%20for%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3026909%22%20slang%3D%22de-DE%22%3ERe%3A%20find%20string%20if%20not%20matches%20replace%20this%20to%20character%20string%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3026909%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1174419%22%20target%3D%22_blank%22%3E%40Quadruple_Pawn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EQuiet%20close%20%2C%20i%20would%20like%20changes%20direct%20in%20Row%20F%20with%20something.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20the%20english%20formular%20%2C%20i%20got%20an%20error%20that%20says%20it%20is%20not%20an%20formular%20(It%20marks%20the%20Klammern)%3C%2FP%3E%3CP%3Ei%20tried%20the%20german%20formular%20from%20the%20pdf%20%2C%20i%20got%20a%20name%20in%20row%20G%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22Is%20it%20allowed%20to%20talk%20in%20German%20here%20%3F%20%22%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3027482%22%20slang%3D%22en-US%22%3ERe%3A%20find%20string%20if%20not%20matches%20replace%20this%20to%20character%20string%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3027482%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1236196%22%20target%3D%22_blank%22%3E%40excelbaer1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(ISNUMBER(SEARCH(%22*%22%26amp%3B%3CFONT%20color%3D%22%23FF0000%22%3E%24%3C%2FFONT%3EI%241%26amp%3B%22*%22%2CF1))%3DFALSE%2C%22something%22%2CF1)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEntschuldigung%2C%20in%20der%20urspr%C3%BCnglichen%20Formel%20hat%20ein%20%24%20gefehlt.%20Ich%20habe%20das%20jetzt%20korrigiert%2C%20siehe%20anh%C3%A4ngende%20Datei%20und%20obige%20berichtigte%20Formel.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello Community can anyone help me to start with excel 

 

I would like to check each cell of a row (F:F) if it not matches with a string ->"keyword

and then replace each cell   with  a string called ->"something

 

I can"t come closer to this goal allone.

 

vba would be great 

 

Thank you very much for your help

5 Replies
best response confirmed by excelbaer1 (New Contributor)
Solution

@excelbaer1 

=IF(ISNUMBER(SEARCH("*"&I$1&"*",F1))=FALSE,"something",F1)

 

Is this what you are looking for?

@Quadruple_Pawn 

 

Thank you Quadruple Pawn , i did it with your formular. 

 

Can you do that also for me in VBA ? 

 

I would like to see and learn from it, couse if i try i can not walk two meters allone in that syntax. 

 

Please if you have time , thank you  

@excelbaer1 

=IF(ISNUMBER(SEARCH("*"&$I$1&"*",F1))=FALSE,"something",F1)

 

Entschuldigung, in der ursprünglichen Formel hat ein $ gefehlt. Ich habe das jetzt korrigiert, siehe anhängende Datei und obige berichtigte Formel.

Huch das hätte mir selber auffallen müssen hatte die Richtige Deutsche Formel genommen mit der ging es. Danke dir vielmals für deine Hilfe

@excelbaer1 Wieder kleiner Vertipper drinn 

 

SOLUTION in

1German  and 2 Englisch  

1

 
Spalte F wird durchsucht ob Keyword in Zelle steht, wenn nicht ändere Zelleninhalt in "something".
In Zelle I1 Zeichenkette eingeben nach der gesucht werden soll. (keyword)
Ausgabe der Formel in neuer Spalte mit 
=WENN(ISTZAHL(SUCHEN("*"&I$1&"*";F1))=FALSCH;"something";F1)

 

Collum F get searched if it not contains keyword , if not change the cell to string something . 

=IF(ISNUMBER(SEARCH("*"&I$1&"*";F2))=FALSE;"something";F2)