In excel,i have a column having the phonenumber and emailid(both in
the same column) how to split into 2 ?
please help me to split the phone number and email id into two
different columns....
example : in column A ,is to be separated as
0998786751 in column B and in column C
note:the length of phone number and email id may vary...
Give me a formula not a macro..
there are 1000's of records like this