Select Not Null "OnActivateSheet" Trigger

[#1]

Hi,

I want to select all not null value on activate sheet please help me how can i achieve this.

[tresesco · Accepted solution]

PFA

[#3]

Great it works,

Thank you Tresesco.

[rwunderlich]

Wouldn't it be easier to user "*" as the Select In Field argument instead of the concat() expression? Or "?" if you wanted to exclude the blank?

-Rob

[tresesco]

You are right Rob Wunderlich, however what I thought is there could be some blank values which appear to be null to the users and are not really so. To handle the case, I thought it would be better to use len(trim())>0.