How to perform function Replace if condition is met?

[NEF1QLSZ4U]

How to perform function Replace if condition is met?

[kuovonne]

Are you asking how to nest formula functions inside each other?

IF(

  condition,

  SUBSTITUTE( string, old_text, new_text)

)

Can you give an example of what you want?

[NEF1QLSZ4U]

If I use FILTER, it is not possible to add replacement. So, replacement is not like Excel. Should we use code inside another filed not FILTER?