a | b | c | d | e | f | g | ||||||||
2 | ||||||||||||||
3 |
<tbody> </tbody> | guy/www/doc | ||||||||||||
4 |
<tbody> </tbody> | word | ||||||||||||
5 | http://www.mrexcel.com// | |||||||||||||
6 |
<tbody> </tbody> | http://www.mrexcel.com/ | ||||||||||||
7 |
<tbody> </tbody> | |||||||||||||
8 |
<tbody> </tbody> | |||||||||||||
9 | seri | |||||||||||||
https://mail.google.com/ |
<tbody>
</tbody>
please
i need to order the cell in f column
in c column
all the cell in f column
that include at lest one character of: /
and put Tham in c column
but the function should ignore empty cell in f column
or word in the cell in f column
without /