View Single Post
 
Old 08-16-2016, 06:03 AM
Mahesh G Mahesh G is offline Windows 10 Office 2013
Novice
 
Join Date: Aug 2016
Posts: 1
Mahesh G is on a distinguished road
Default How to substring and trim in excel

Hi,
1) I am getting data like this in a field customer name. I am manually doing name and email fields by cut and paste and delete etc.
abcd exacfareasa
(abcd.exacfareasa@xyatdns.com)
(sip:abcd.exacfareasa@xyatdns.com)

I wanted to write a function it should trim data like
Name email
abcd exacfareasa abcd.exacfareasa@xyatdns.com
Reply With Quote