|
|
|
|
#1
02-16-2017, 05:37 PM
|
|||
|
|||
Try...
D2 =LEFT(C2,FIND(",",C2)-1) E2 =MID(C2,FIND(",",C2)+2,LEN(C2))+0 F2 =YEAR(E2) Note: Format E2 as a date 
|
|
| Tags |
| parse data, text to columns |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Documents with two columns only have one column after update | Nomis69 | Word | 5 | 04-05-2016 02:29 PM |
 Need code to Parse and arrange data based on heading
|
winmaxservices2 | Excel Programming | 1 | 01-01-2015 01:04 AM |
| Split one column to several columns | moishy | Excel Programming | 1 | 02-01-2013 12:50 AM |
| Columns. How to move the left column so it's to the right of the 'right' column ? | Vit | Word | 9 | 11-21-2012 12:57 PM |
|
How to expand one column into two columns?
|
Jamal NUMAN | Excel | 1 | 01-12-2011 07:59 PM |
Windows Vista 
Office 2007
Hybrid Mode