Forum Discussion

almaskm's avatar
almaskm
Copper Contributor
Aug 01, 2023

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.

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    almaskm 

    If to replace the text in the same cell that's with VBA, or it is enough to place result into another cell?