I have to delete "New Cell Data" cell from excel but its Cell dynamically changing in Future

[shaik.muktharvalli1 (shaik muktharvalli)]

If “New Cell Data” found in cell then I have to delete “New Cell Data” cell from excel but its Cell dynamically changing in Future

Thanks
Shaik Muktharvalli

[Shiva_Nikhil]

@shaik.muktharvalli1

use find/Replace activity

cheers

[Yoichi]

Hi,

Can you try to use FindReplace Value activity in MatchAll mode with MatchEntireCellContents option as the following?

Regards,

[shaik.muktharvalli1 (shaik muktharvalli)]

I have to find and delete cell

Thanks
Shaik

[Yoichi]

HI,

Is your expected output as the following?

If so, the above sample will work.

OR Do you need to shift rows to upper?

Regards,

[shaik.muktharvalli1 (shaik muktharvalli)]

working fine Thank you @Yoichi