How to Find Null Excel Cell?, and if null cell match writes "NA" in cell

Hello,

I have extracted this data via Table Extraction and stored it in Excel, but in the “Rating” field some company has no rating that is why some cells are null in the “Rating” field.

I want to replace this null cell with “NA”
can anyone help me

Thank you.

Hi @Anonymouss

Try this

Cheers!!

1 Like

Hi @Anonymouss

You can use the Find/Replace activity to replace the Empty cells with NA.

Select the Replace All option from the operation dropdown, give the Type.missing in Value to find field and give the “NA” in Replace with field.

Check the below image for better understanding,
image

Hope it helps!!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.