i need to count the number of caracter in a cell and add a condition
For example : If Cell A1 there is 2 digit (for example : 25) then add “A” after
If If Cell A1 there is 1 digit (for example : 5) then do nothing
i need to count the number of caracter in a cell and add a condition
For example : If Cell A1 there is 2 digit (for example : 25) then add “A” after
If If Cell A1 there is 1 digit (for example : 5) then do nothing
HI @Soudios
Use assign activity as follows,
NewValue = if(cellValue.length=2,“A”,cellValue.length=1,“”)