How to check cells having numeric values in excel

[Kavyasri (Kavya)]

Hi, NoNumber.zip (2.4 KB)
I tried this process but not getting the expected output.
Input

If “Address” Column does not contain numeric values then the “Status” should be “B” otherwise Blank

Output I need

Tried many processes but not getting Result correctly…It would be of great help if anyone suggests me some idea for this.
Thanks & Regards.

[Srini84 (Srinivas)]

@Kavyasri

You can use Read Range and Foreach row and Check as below

False if no number

For reference of Read Range and Foreach row and placing the value in datatable, check below

Convert Date & Time Format Tutorial

[How to Convert Date and Time Format using UiPath || RPA UseCase] Thanks

Like and vote if this helps you

Mark as solution if this helps

Thanks

[Kavyasri (Kavya)]

Hi @Srini84 , Thanks for the reply…You are doing it by taking seperate statements…But I want to do taking everything at once using simple conditions…Can you suggest me any idea…NoNumber.zip (2.4 KB)
I used read range and for each loop also,once see this workflow and please tell me if anything is wrong.

[Srini84 (Srinivas)]

@Kavyasri

I have given you the sample, can you provide your sample excel file

I will make some changes to your flow

Thanks

[Srini84 (Srinivas)]

@Kavyasri

Check attached

NoNumber.zip (2.6 KB)

Test with your excel file and let me know if you have any issues

Thanks

[Kavyasri (Kavya)]

Data.xlsx (9.3 KB)
Thanks @Srini84 ,This is the one

[Kavyasri (Kavya)]

okay…thank you

[Srini84 (Srinivas)]

@Kavyasri

Below is the result

Mark as solution if this helps

Thanks

[Kavyasri (Kavya)]

Yeah @Srini84,Its working…Thank you so much…Can you please explain me this as I am not aware of this function

[Srini84 (Srinivas)]

@Kavyasri

That’s a regex function to identify the number

ISMatches will return the true or False

Thanks

[Kavyasri (Kavya)]

Ok…Got it.Thank you @Srini84