Change a value if a string is contained in another cell

[xpander]

If column Words contains *text* then update column Code to "POSTED" otherwise do not update column Code

[Welshgasman]

Crossposted https://www.access-programmers.co.uk.../#post-1913866

[June7]

This can be calculated when needed, not necessary to actually save into table. But if you really must edit all records:

UPDATE tablename SET Code = "POSTED" WHERE InStr(Words, "something") > 0;

Do you want to match the literal value of "*text*"? Or is this some variable input?

Oh, so this is Excel not Access?