Fill blank data with '-'

[Palaniyappan (Palaniyappan P)]

Hi

Check this thread for a xaml sample on the same note

Find/replace Value: I want to find empty cellls in a excel file and replace with 0

as you are lookin for “” Empty string it will not catch a space The provided Excel contains space on the cellls which are looking blank it is risky but you can try first run - replace " " with “” second run - replace “” with 0 When doing this on Datatable level, then you would have a better control on it, as you can use the trim method and would not harm spaces within texts

Cheers @Pranay_Kumar_Bose