Text box prompt and blank values

[Dampa]

Hi everyone,

Most of the times, when I copy values from Excel and paste to a Text box prompt (Multi-select and Multi-line on), I have a last row blank (A) that I need to remove.
If I forget it, all the blank values (millions of lines) will be extracted as well.

In another prompt, if the last row is blank, it prevents me to go ahead (B), making the prompt red as if it was mandatory. Mistakes are not possible here.
In this case the query item is converted to integer, but I cannot do this to query (A) as it can contains both text and numbers.



Do you have other solution to do not consider blank lines or to avoid that they are inserted by mistake?

Thanks,
D