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, 02:18 PM

texascpa

texascpa is offline

texascpa uses Windows XP

Windows XP texascpa uses Office 2010 64bit

texascpa uses Office 2010 64bit

Office 2010 64bit

Novice

The original poster

Join Date: Sep 2012

Posts: 19

texascpa is on a distinguished road

Default

Parse data in one column to 3 other columns

I have the following information in Column C:

Monday, January 10, 2017

I want the day in Column D, date in Column E, and the year in Column F

I have been trying to do so using the Text to Columns function but without success. I am using Office 2016.

Thanks for you help

TexasCPA

Reply With Quote