Finding alphanumeric words in a cell and setting the value to 1

[Abhii2658]

I have 70,000 records with various information fields. The requirement is from the Vendor field, if there is an alphanumeric value then set Field A to 1 else to 0

Example 

Name                                            Field A 

AB1000 Abhijeet Company AB  -     1

CD2000 Abhijeet Company AB  -    1

EF3000 Abhijeet Company AB -      1

AB1234 Abhijeet Business AB -       1

AB01 Abhijeet Games -                    1

IT2658 Abhijeet Company AB -         1 

123456 Abhijeet Company AB -        0

45 Abhijeet Company -                      0 

Hope i am making sense here. Appreciate any advise here. 

[atcodedog05]

Happy to help : ) @Abhii2658 

Cheers and have a nice day!