Archive of Mr Excel Message Board

Back to Dates in Excel archive index
Back to archive home

Chopping up date

Posted by Jason on April 10, 2001 8:56 PM

If I have a cell with a text value of (no quotes):
'Mar 3 1969'

is there a way to seperate the 'Mar' the ' 3' and the '1969' into seperate cells? Basically I want to chop up the text string into seperate cells

Re: Chopping up date

Posted by Dave Hawley on April 10, 2001 9:07 PM

Hi Jason

Let's suppose your text is in cell A1. Use these formulas

To get the Month
=LEFT(A1,3)

To get the Day
=MID(A1,5,1)

To get the year
=RIGHT(A1,4)

Or alternatively you could use the "Text to Columns" wizard, found under "Data" on the main menu.

Dave

OzGrid Business Applications

Re: Chopping up date

Posted by Jason on April 10, 2001 9:16 PM

Thank you very much your help is greatly appreciated. I will reccommend your site to all that I know.

Jason

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.