formulae which will identify the presence of a dot (.)
Posted on 2011-02-10
Need a formulae which will identify the presence of a dot (.) in a text string and if the condition is met, the formulae will return true.
Example (cell A2)
Xyz.xls Formulae should return ‘True’
The idea is that if the result of the find/search formulae is true, then i would like to put “”, no character, else put the valuein the cell A2.
Kindly provide the formulae for the same.