Hello All,
i need to split the some data like :
Ahmed // ABC.com // call // 123456789
or
Ahmed // Abc.com // Mail // abc.com issue
and i need when ever the excel find that format *.com/*.net/*.edu put that data in product column and wherever find number put it in the number column
o know i should use split but i don't know how ????
to be
like that format :
<tbody>
</tbody>
i need to split the some data like :
Ahmed // ABC.com // call // 123456789
or
Ahmed // Abc.com // Mail // abc.com issue
and i need when ever the excel find that format *.com/*.net/*.edu put that data in product column and wherever find number put it in the number column
o know i should use split but i don't know how ????
to be
like that format :
name | product | contact way | number | subject | issue |
AHMED | ABC.COM | call | 123456789 | ||
ahmed | abc.com | abc.com issue |
<tbody>
</tbody>