MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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

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

To get the Day

To get the year

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


OzGrid Business Applications

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.