Hi guys,

I want to check whether the cell only contains number and not mixed with letters.

i have combine multiple if

note : first cell is P167, second cell is AI167

first check whether the cell length is 26 character

second is to make sure the first cell and second excel data is same

and third check whether the first cell or even the second excel is only contains number (not mixed with letters)

If excel function cannot provide this as when i’m using write cell activity, are there any option to check within uipath? Maybe using some regex or another function but i’m not too familiar with that.

this is the formula that im trying to use

=IF((AND(LEN(AI167)=26;P167<>AI167;P167="";ISNUMBER(VALUE(P167))=TRUE;ISNUMBER(VALUE(AI167))=TRUE));“Not Match!”;

Sorry for asking some silly question and really appreciate it for any feedback

Thank you

Delf