Whatever other data you want in the cell if the criteria is not met should be
your third parameter. Or, your third parameter could be another if statement
to test for some other data, and if that is not found, return a "". Unless
they are nested or concatenated, two functions or pieces of data cannot
occupy the same cell.

IF(A1="yes",A1,other data)

IF (A1="yes",A1,IF(test for other data, other data, ""))


" wrote:

Not exactly (thanks for the try)... that puts a blank where some test
was that I want to keep.

It would be more like =IF(A1="yes","yes", DO NOTHING)

where do nothing means leave that cell alone!

Befo
A B
1 example text (blank)
2 BlahBla goodstuff
3 example text (blank)

After:
A B
1 example text example text
2 BlahBla goodstuff
3 example text example text