1

I'm using Excel version 15.27 on Mac and I want to get value from first column cells (A) and adding it to the last column cells (D) only if the cell from column A doesn't contains any number .

For example in column A :

plan/3432 >> Don't take this value

343343 >> Don't take this value

Neighborhood Name >> Take this value

How to do this ?

2

With your data in column A, in D1 enter the formula:

=IF(COUNT(FIND({0,1,2,3,4,5,6,7,8,9},A1))>0,"",A1)

and copy down:

enter image description here

Any A cells containing numerals will not appear in column D.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.