Microsoft Office Forums - View Single Post - [Solved] Parse data in one column to 3 other columns

Thread: [Solved] Parse data in one column to 3 other columns

View Single Post

Old

02-16-2017, 05:37 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

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

Reply With Quote