text separation by formula, please have a look color marks text
cell A1 = +819038031597 · k123hiro@gmail.com · Japanese
from above data i need to separate Mobile number & email number like below
cell B1 = 819038031597
cell C1 = k123hiro@gmail.com
Again for below
Cell A2 = Thursday, May 2, 2013 at 18:35:21 · #664055610
from above data i need to separate Mobile number & email number like below
cell D1 = Thursday, May 2, 2013
cell E1 = 664055610
Bookmarks