jeudi 15 août 2019

How to give true and false condition if my column have text and number

My A column contains texts and numbers

'DP','SP','KP','4','10'

I want to get data like if my A column contains text then '0', if it is numeric then '8' in the column B. How do I do that?

Aucun commentaire:

Enregistrer un commentaire