Forum Discussion
Replace
Hi, I need a formula to replace the cells in the column, which contains multiple sentences, with a single word(abc) if the cell contains a particular word(xyz) in it. Please help.
If to replace the text in the same cell that's with VBA, or it is enough to place result into another cell?