|
|
#1
08-16-2016, 06:03 AM
|
|||
|
|||
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 |
Windows 10 
Office 2013
Linear Mode
