#1
|
|||
|
|||
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 |
Tags |
formatting data, substr, trim |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Substring to return numbers | funkyfido | Excel | 4 | 07-22-2016 10:03 AM |
Data Entry - Getting spreadsheets back with excess space but the TRIM function doesn't work | jhato160 | Excel | 5 | 06-17-2016 04:06 AM |
VBA code to trim a picture | capitala | Word VBA | 3 | 12-02-2013 04:26 PM |
Excel 2011 can't open old Excel 98 or Excel X files | FLJohnson | Excel | 8 | 05-09-2012 11:26 PM |
Multiple Audio Tracks - Won't trim? | Hlogan89 | PowerPoint | 0 | 09-12-2010 01:33 PM |