How to check cells having numeric values in excel

Help Studio
1

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

Screenshot (737)
Screenshot (737)1389×754 48.7 KB

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

Output I need

Screenshot (742)
Screenshot (742)1328×708 45.9 KB

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

2

@Kavyasri

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

image
image1124×411 19.5 KB

False if no number

image
image1247×414 19.9 KB

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

Like and vote if this helps you

Mark as solution if this helps

Thanks

3

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.

5

@Kavyasri

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

I will make some changes to your flow

Thanks

6

@Kavyasri

Check attached

NoNumber.zip (2.6 KB)

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

Thanks

7

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

8

okay…thank you

9

@Kavyasri

Below is the result

image

Mark as solution if this helps

Thanks

10

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

Screenshot (754)
Screenshot (754)1408×958 19.5 KB

11

@Kavyasri

That’s a regex function to identify the number

ISMatches will return the true or False

Thanks

12

Ok…Got it.Thank you @Srini84