Many people find the process to conceal comma in NEIS rather challenging, especially if they don't regularly work with paperwork. However, today, you no longer have to suffer through long instructions or wait hours for the editing software to install. DocHub enables you to edit forms on their web browser without setting up new programs. What's more, our powerful service provides a complete set of tools for professional document management, unlike numerous other online tools. That’s right. You no longer have to donwload and re-upload your forms so often - you can do it all in one go!
No matter what type of paperwork you need to modify, the process is straightforward. Benefit from our professional online solution with DocHub!
couple of minutes ago someone came to my desk and asked me how do you add all these numbers here that is actually separated by a comma this is how you do it first youamp;#39;re gonna have to split this cell value into an array youamp;#39;re going to use a function called text split and then the first argument on the text plate will be the cell where the numbers are comma and the second argument is your delimiter which is your comma itself and this will create an array of numeric value which is in string to convert them youamp;#39;re going to have to use a Double Dash which is also known as a double unary operator which basically converts the string of numbers into actual numbers where you can do math once thatamp;#39;s done you use the good old sum function and then you are done for that row so after that to apply to all the row just drag on this Handler and then you are done