How to know the cell is empty in excel

if the cell D3 is empty… then it should ignore the next formula…how we give this formula in excel

Hi

We can use read cell activity and get the output as a string variable named Strinput where mention range as “D3”

Then use a if activity with a condition like

String.IsNullOrEmpty(Strinput.ToString.Trim)

If true it means as empty then it goes to then block where you can proceed with next cell in same way

Cheers @Bhargavi_Lokapur

1 Like

@Bhargavi_Lokapur

It’s better if you use Datatable and write as @Palaniyappan suggested

If it didn’t works for you, better give some more inputs with some screenshots

Thanks

I dont want to apply it in uipath. I want to apply this formula in excel

Original formula
=CONCATENATE(TRIM(LEFT(D2, FIND("^",SUBSTITUTE(D2, " “, “^”,2)&”^")))," “,“INV NO”,”-",E2," “,TRIM(LEFT(D3, FIND(”^",SUBSTITUTE(D3, " “, “^”,2)&”^")))," “,“INV NO”,”-",E3," “,TRIM(LEFT(D4, FIND(”^",SUBSTITUTE(D4, " “, “^”,2)&”^")))," “,“INV NO”,”-",E4," “,TRIM(LEFT(D5, FIND(”^",SUBSTITUTE(D5, " “, “^”,2)&”^")))," “,“INV NO”,”-",E5)
Output-DYNAMIC AGRO INV NO-DAI-168/01/21-22 INV NO- INV NO- INV NO-

expected O/P:-DYNAMIC AGRO INV NO-DAI-168/01/21-22

here if D3 is blank …then next formula should ignore and “INV NO” which is manually written… it should not write.

Original formula:-
=CONCATENATE(TRIM(LEFT(D2, FIND("^",SUBSTITUTE(D2, " “, “^”,2)&”^")))," “,“INV NO”,”-",E2," “,TRIM(LEFT(D3, FIND(”^",SUBSTITUTE(D3, " “, “^”,2)&”^")))," “,“INV NO”,”-",E3," “,TRIM(LEFT(D4, FIND(”^",SUBSTITUTE(D4, " “, “^”,2)&”^")))," “,“INV NO”,”-",E4," “,TRIM(LEFT(D5, FIND(”^",SUBSTITUTE(D5, " “, “^”,2)&”^")))," “,“INV NO”,”-",E5)
Output-DYNAMIC AGRO INV NO-DAI-168/01/21-22 INV NO- INV NO- INV NO-

expected O/P:-DYNAMIC AGRO INV NO-DAI-168/01/21-22

here if D3 is blank …then next formula should ignore and “INV NO” which is manually written… it should not write.

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